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.
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