hai all forums members,
I wont to use bulk insert get data from csv.
my db Table colun Name -- > Item_Id, ItemCode, ItemName here Item_Id --> PrimaryKey
I export Only ItemCode and ItemName column values ...
When i import ItemCode and ItemName using sql query like
" BULK INSERT ItemDetails FROM '" + strFileName + "' WITH ( FIRSTROW = 2, KEEPIDENTITY, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n') "
but I have a error like
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 1 (Item_Id).
What can i do?
Please help me.....
Go to the complete details ...