pabaras
Reputation: 51
Error while importing data into a SQL Server 2012 table
I want to import data into a table and when I finish the wizard, I get these errors and I don't know why.. Any help?
Upvotes: 1
Views: 114
Answers (1)
LONG
Reputation: 4610
you have identity column defined in the destination table, go back to the previous import wizard page (based on your pic), go to edit mapping, check allow identity insert
Upvotes: 1
Related Questions
- Stored Procedure to import data into SQL Server database... Error
- Getting error while importing data from MySQL into SQL Server
- SQL Server cannot use the "import Data" function
- Error Inserting Data into tables in SQL Server
- SQL Server: Data import errors
- Having problems importing CSV into table
- try to import query, show error
- Error when importing a file into SQL Server
- Must declare the table variable
- Import data in Microsoft SQL Server