csv file import to sql server

Nishant Mittal11y ago

Hi,

Then u have to play with the code like provided in below link

http://www.codeproject.com/Articles/30705/C-CSV-Import-Export

0

Ekrem Tapan11y ago

Nishant Mittal hi,

have a blank like that this

A025A09853 TCLU5174662 CV:CFS INBOUND FULL CONTAINER 20150719TWKELN528

0

Nishant Mittal11y ago

Hi,

But without comma how you will segregate your data? There should be something like that ??

0

Ekrem Tapan11y ago

Nishant Mittal thanks for ur reply, before i already seen this article but i wanna use file upload method importto sql server and my csv file without comma... do u have a any suggustion ? most important problem for me if line start to blank no data like that line 3 how can i read and save sql server ?

0

Nishant Mittal11y ago

Hi,

best reply by Pinal

http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

0