Gazthrak
06-09-2008, 11:23 AM
Hello,
I have a tab delimited text file (4 columns) that i would like to import into a MSSQL 2000 DB and have it automatically create the identity fields as it is imported. However, when I try to do an import, it tries to import the ID field as NULL, even when i select "enable identity insert" and tell it to ignore the ID field. This causes an error and I can't import.
I feel like I am missing something simple but i cant find it. Any thoughts?
Thank you.
I have a tab delimited text file (4 columns) that i would like to import into a MSSQL 2000 DB and have it automatically create the identity fields as it is imported. However, when I try to do an import, it tries to import the ID field as NULL, even when i select "enable identity insert" and tell it to ignore the ID field. This causes an error and I can't import.
I feel like I am missing something simple but i cant find it. Any thoughts?
Thank you.