Hello,
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.
...
Go to the complete details ...