OPENROWSET load data from CSV file

Question

In SQL Server 2008 this worked fine, but does not work on 2014. Please help load data same way from csv

 
           SELECT *  --- worked on ol
      
           FROM OPENROWSET
('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\Users\ekokota\Desktop\SF\;',
 'SELECT * from RecordTypes.csv');

Answer 1

Hi @Alan5896

2014 version seems to be an old version. The Official documentation about OPENROWSET could not be found for the 2014 version. You can try the usage in the 2016 version.

https://learn.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-2016

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

but does not work on 2014.

"Not work" means waht in details? Do you get an error message and if,which one?

DBQ=C:\Users\ekokota\Desktop\SF\

You locate the file in a user profile folder, where only the user "ekokota" do have access for, but not the SQL Server service account. Move the file to folder, where SQL Server have at least read permissions for.