Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
EZEK
Starting Member
8 Posts |
 Posted - 2008-02-08 : 07:04:37
|
| hi, im having problems to import data from my excel to a sql table.in the excel file i have exact the same fields that i have in the table excepts the primary key which is an auto increment. When i try to import data, an error that i can't insert nulls into my auto increment column.I put enable identity insert in the edit options, but still doesnt work.can anyone help?thanks in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-08 : 22:31:46
|
| Dup post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97026 |
 |
|
|
|
|
|
DTS auto increment column and excel