From MS Access 2003 table to "identical" MS SQL Server 2005 table
Hello there!
When I try
SET IDENTITY_INSERT Stocks ON
INSERT INTO Stocks
SELECT Access.*
FROM OPENROWSET('Microsoft.Jet.
'C:\PathToDatabase\Databas
I get the following error:
Msg 8101, Level 16, State 1, Line 5
An explicit value for the identity column in table 'Stocks' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Please explain the error and correct what is wrong.
Note: there are 2 identical Primary Key´s at Access and SQL Server, both called StockID.
Thanks,
fskilnik.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect, BriCrowe. Thanks for the quick and explicit reply.
Please have a look at my other (I guess harder) question, if you don´t mind!
Here: https://www.experts-exchange.com/questions/21902340/Named-Piper-Provider-Could-not-open-a-connection-to-SQLServer-2-Error.html
Thanks a lot,
fskilnik