TBSupport
asked on
Column is specified more than once in the “SET” clause
Hello:
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.
Thanks!
TBSupport
CertsLicTrain-EHW-Employee-Templ.xlsx
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".
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.
Thanks!
TBSupport
CertsLicTrain-EHW-Employee-Templ.xlsx
ASKER
Hi Brichsoft:
It's select * from [spreadsheetname$]
The import tool has a UI that allows us to map fields from the select statement into fields in the table that we're trying to import into.
TBSupport
It's select * from [spreadsheetname$]
The import tool has a UI that allows us to map fields from the select statement into fields in the table that we're trying to import into.
TBSupport
is there any trigger?
ASKER
No. Good question.
TB Support
TB Support
Hello,
I just tried to import same worksheet with help of "SQL Server Import & Export Wizard" and it did not give any error. Please find attached .png file here.
BTW, which import tool is using?
Best Regards,
Mohit Pandit
Snap-01.PNG
I just tried to import same worksheet with help of "SQL Server Import & Export Wizard" and it did not give any error. Please find attached .png file here.
BTW, which import tool is using?
Best Regards,
Mohit Pandit
Snap-01.PNG
ASKER
SmartConnect.
It might be a moot point, though. I had to get this done, ASAP, and was able to get this data imported through Microsoft Dynamics GP's Table Import tool.
I am curious, though, as to why this error comes about in SmartConnect. Their tech support never got back to me, and I had to move forward.
TBSupport
It might be a moot point, though. I had to get this done, ASAP, and was able to get this data imported through Microsoft Dynamics GP's Table Import tool.
I am curious, though, as to why this error comes about in SmartConnect. Their tech support never got back to me, and I had to move forward.
TBSupport
hi,
problem is
either one column is inserted twice, either virtually or
or
there could be some trigger, which may affecting.
if you can share us whole error message, it help us to give reply
problem is
either one column is inserted twice, either virtually or
or
there could be some trigger, which may affecting.
if you can share us whole error message, it help us to give reply
ASKER
All of the columns get this error, but here is the one for the EmployeeID column:
The column name 'EmployeeID' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once.
TBSupport
The column name 'EmployeeID' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once.
TBSupport
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
can you share your query with us.
between for your reference, you can check out the link.
http://exacthelp.blogspot.