csv file import to sql server

Question

hi everybody i have a csv file like that below each color represent each column so how can i insert to sql server ? A025A09853 TCLU5174662 CV:CFS INBOUND FULL CONTAINER 20150719 TWKEL N528 A065A01976 IAAU2694610 FB:LADEN CONTAINER LOADED ON 20150719 TWKHH S164 GESU6506686 MA:EMPTY CTNR DISCHARGED FM 20150719 HKHKG

Nishant Mittal · Answer

Hi Then u have to play with the code like provided in below link http://www.codeproject.com/Articles/30705/C-CSV-Import-Export

Ekrem Tapan · Answer

Nishant Mittal hi have a blank like that this A025A09853 TCLU5174662 CV:CFS INBOUND FULL CONTAINER 20150719 TWKEL N528

Nishant Mittal · Answer

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

Ekrem Tapan · Answer

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 ?

Nishant Mittal · Answer

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/