BULK SQL Query in SQL

Question

Dear, I'm inserting CSV data into SQL Server. Below is the code. BULK INSERT AA_Temp FROM 'D:\A\33.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '
' ) GO What my problem is my CSV file has a header, without having header is successfully inserted. How to skip the first header, i tried above code but got error type mismatch beocz of getting first header row. Thanks Basit

Jignesh Trivedi · Accepted Answer

Hi, TRy Create table #temp (id int, name varchar(50) ) BULK INSERT #temp FROM 'D:	est.csv' WITH ( FIRSTROW = 2, FIELDTERMINATOR = ',', ROWTERMINATOR = '
' ) hope this will help you.

Basit Khan · Answer

Thanks Jignesh,   Problem Solved, becoz of csv file, in sql data type problem.   Thanks Basit.

Jignesh Trivedi · Answer

Hi, Ok, can you please share your csv data and table definition?

Basit Khan · Answer

Thanks Jignesh,   I used below code BULK INSERT AA_Temp FROM 'D:\A\66.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '
', FIRSTROW = 2 ) GO   Showing (0 row(s) affected). But when i delete the header row its inserted.   Thanks Basit

Raja T · Answer

Hi, Please check out below links   http://stackoverflow.com/questions/13056929/bulk-load-data-conversion-error-type-mismatch-or-invalid-character-for-the-spec   http://stackoverflow.com/questions/7490542/fun-with-bulk-insert-sql-server-type-mismatch-or-invalid-character-for-the-spe   http://www.codeproject.com/Questions/801211/Bulk-load-data-conversion-error-type-mismatch-or-i    http://blogs.technet.com/b/heyscriptingguy/archive/2011/11/28/four-easy-ways-to-import-csv-files-to-sql-server-with-powershell.aspx