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 : 09:21:58
|
| i've posted in the wrong forum, so im posting herehi, 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 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-08 : 11:54:17
|
| In the mapping section, have checked to see if the excel columns are matching the approriate SQL Server table mappings?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
DTS auto increment column and excel