Attached is an Excel workbook containing tabs of data that I need to import into SQL tables. There is an import tool that we use, for such activity.
In particular, I'm having an issue with the tab called "EmployeeTrainingCourses".
When I conduct the import of this data directly into a SQL table, I get the error message saying that the "Column [whatever] is specified more than once in the 'SET' clause".
I read online that this is a fairly common error message. But, I don't see anything online addressing this error in terms of importing data.
The data is just what it looks like in the spreadsheet. I simply want to import each row as a record in the table. It should be pretty straightforward. So, I don't know why I'm getting this message.
Any help is appreciated.