Inserting CSV File to SQL SERVER TABLE
-
Hi, I'm having csv file which i tried inserting into sql server 2000 table through bulk insert my bulk insert statement Bulk Insert TableName From '\\FilePath\FileName.csv' With ( FieldTerminator = ',', RowTerminator = '\n' ) While Executing the SQL Statement, i'm getting the following error. Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. i tried inserting through DTS it works. but i want to do through Application How to do that. Please Help Me.. Thanks, Regards, P.Prakash.
-
Hi, I'm having csv file which i tried inserting into sql server 2000 table through bulk insert my bulk insert statement Bulk Insert TableName From '\\FilePath\FileName.csv' With ( FieldTerminator = ',', RowTerminator = '\n' ) While Executing the SQL Statement, i'm getting the following error. Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. i tried inserting through DTS it works. but i want to do through Application How to do that. Please Help Me.. Thanks, Regards, P.Prakash.
Just a guess, but for the final record, is there a row terminator?
Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]
-
Hi, I'm having csv file which i tried inserting into sql server 2000 table through bulk insert my bulk insert statement Bulk Insert TableName From '\\FilePath\FileName.csv' With ( FieldTerminator = ',', RowTerminator = '\n' ) While Executing the SQL Statement, i'm getting the following error. Bulk Insert: Unexpected end-of-file (EOF) encountered in data file. i tried inserting through DTS it works. but i want to do through Application How to do that. Please Help Me.. Thanks, Regards, P.Prakash.
Hi prakash, Check for the Extra spaces at the end of the file.If so remove those spaces and retry it.
-
Just a guess, but for the final record, is there a row terminator?
Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]
In the CSV File i think i'm not getting proper row terminator (\n) at the end of the file. in that case how to proceed with bulk insert? One more thing while importing the same csv file through dts then i'm able to import the CSV File data to the table. but i want to do it in the applications. pls kindly help me. P.Prakash.