Read unicode txt csv file data in Sql server?
i am using simple query to import CSV file to Sql Database. this is
returing only single column (name Like  ) instead of all column( there
are 15 column). i tried it to save as again then it is working fine.
but manually i cant change it . SELECT *
FROM OPENROWSET('MSDASQL','
Driver={Microsoft Access Text Driver (*.txt, *.csv)};
Extensions=asc,csv,tab,txt;
Persist Security Info=False;
CharacterSet=unicode;
Dbq=C:\LTA Masterfile Conversion\;
Format=Delimited(|)','select top 20 * from LTADATA.csv')
please help asap.
No comments:
Post a Comment