MS SQL Server New Users

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Data Import

TriAdX@aol.com

2005-03-30, 7:04 pm

I am trying to import a spreadsheet to my database

i have all columns that need to beed populated filled out. EXCEPT my ID
column.
this is my index and automatically creates the next ID in line.

how can i APPEND my spreadsheet to my database and let it assign the correct
ID's
(the next available incriment)
when i try to import using the import feature in Enterprise Manager it gives
me:

Destination does not allow NULL on column pair 1 (soucre column 'cat_id'
(DBTYPE_WSTR), desination column 'cat_id'(DBTYPE_14))

any help please?

Sponsored Links