I am trying to import into sql server from a .csv flat file i made in excel. The problem is the Primary Key. It is set to auto increment.
When i leave an empty column i get:
"Directcopyxform conversion error:destination does not allow null"

when i just omit the column entirely, i get a wrong datatype error because it basically tries to copy all the columns 1 shift to the left

How am i supposed to represent and auto PK in .csv file

rrr

__________________
rrr

You cannot have EMTPY/NULL for that columns that is set as PRIMARYKEY. All Rows should contain values in it for primarykey column. Also ensure that you have set that up to ALLOW NULL for all other columns in the design veiw of the table on SQL server.

Cheers!

_________________________
- Vijay G
Strive for Perfection

my intent is not to have Null value in primary key, the problem is the syntax to use in the .csv file. I have a .csv file that i need to insert into the table but the problem is that the primary key is set to auto incrememnt. for example

pk | col1 | col2
1 | a | a
2 | b | b

if i was to use this in my .csv file: "","c",c"" i get a NULL exception
I also cannot just leave out the column entirely: "c","c" or i will get a datatype exception cause it will try and copy it into the pk column,

any suggestions? is my only choice to manually insert the primary keys? that means i have to keep track of the current number everytime i want to import type a .csv file which will be imported and start from there


rrr

I would suggest you not to use IDENTITY/auto increment field for PK.

_________________________
- Vijay G
Strive for Perfection