Tuesday 24 December 2013

Microsoft Access: Error copying data to Sharepoint

Error Reproduction:
1) Open Excel file in Access
2) EXTERNAL DATA --> More --> SharePoint List


Error message:
There was an error copying data to a SharePoint list.Duplicate output destination 'Title'.



Workaround:
In my case that was a column with the title "title", just by removing it from the source Excel sheet, the export completed successfully, and even with the column title in the destination!

Another recommendation I read somewhere was to rename the Excel sheet filename to eliminate any special characters, which wasn't my issue.

No comments:

Post a Comment