UselhjtestCreate Table#temp6//Create A temporary table (Anvarchar(Max) not NULL, Bnvarchar(Max), Cnvarchar(Max), Dnvarchar(Max), Envarchar(Max), Fnvarchar(Max), Gnvarchar(Max), Hnvarchar(Max), Invarchar(Max), Jnvarchar(Max), Knvarchar(Max), Lnvarchar(Max), Mnvarchar(Max), Nnvarchar(Max), Onvarchar(Max), Pnvarchar(Max), Qnvarchar(Max), Rnvarchar(Max), Snvarchar(Max), Tnvarchar(Max), Unvarchar(Max), Vnvarchar(Max), Wnvarchar(Max), Xnvarchar(Max), Ynvarchar(Max) )BULK INSERT#TEMP6//Read CSV to temporary table from 'h:\ Data \a-z.csv' with(FieldTerminator=',',//represents the delimiter for different fields in each row of a CSV file Rowterminator='\ n'//indicates that there is no line separation between peers with carriage return newline)GoINSERT intoNNN (NNN,TTT)SELECTA,c from#TEMP6//Insert a part of a temporary table into the NNN table
Read the CSV file into the database