goofyui
Reputation: 3492
Import Excel to Auto-Identity Enabled Table
I am trying to Import an Excel Sheet to an Auto Identity Enabled Table.
As Auto - Identity ( Id Column ) is set to Not Null - I am not able to Import Excel Sheet.
How should i do this ??
Upvotes: 0
Views: 661
Answers (1)
user756519
Reputation:
Do not map any Excel column to auto identity column in the table. That should help you to import the Excel sheet.
Upvotes: 1
Related Questions
- Import data to SQL Server table from Excel
- SSIS : Importing data from an Excel source into a SQL Server database
- Import from Excel to SQL using SSIS
- SSIS import of Excel File
- How to create identity column when importing data from Excel into MS SQL Server (with Import and Export Wizard)?
- SSIS Importing Excel Data
- SSIS Import: From Excel to SQL Server
- Importing Data from excel into sql server
- Identity Inserts using SSIS Import Export Wizard
- SQL Server 2005 Import from Excel