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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-25 : 08:12:29
|
| Mark writes "When trying to import into a table from Excel using DTS I am receiving an error 'cannot insert the value NULL into column.... column does not allow nulls. Insert fails.According to the message, this occurs 'at destination for row number ??' which is the last row to be inserted.The table has a primary key which is an identity column and is a foreign key to another table.FYI my requirement is to populate a SQL database from an Excel spreadsheet. The table being loaded is to contain unique team Ids from the xls.I am running SQL server 2000 on windows XP pro SP2" |
|
|
|
|
|
DTS import from Excel