My bad - its actually sqlbulkcopy class that I am using, though functionally it is the same as bulk insert.
Here is my connection string
Provider=Micros oft.Jet.OLEDB.4 .0;Data Source='C:\temp \temp.csv';Exte nded Properties='tex t;HDR=No;FMT=De limited'
lets say this is my target table, Column C and Column H are the ones thats causing the issue.
[A] varchar(30),
[B] varchar(90),...
clarkie342
Last Activity: Jan 23 '09, 12:54 AM
Joined: Jan 22 '09
Location:
-
No. Can I specify the field type in the format file?Leave a comment:
-
BULK INSERT not inserting string with 'D'
I am using BULK INSERT to load one of my files into the database. I noticed that values like 5D08, 08D038 is getting converted to numeric values like 500000000 and 8E+38 resp even though the field in the database is varchar. Has anybody seen this before? How can I prevent this?
Thanks.
No activity results to display
Leave a comment: