Home › SQL Server › SQL Server OPENROWSET

SQL Server - Reading information from a CSV file using OPENROWSET


Connecting to a CSV file and reading information from SQL Server using OPENROWSET

-- Directory: c:\temp
-- Filename: data.csv

SELECT *
FROM OPENROWSET(
  'MSDASQL',
  'Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=c:\temp\;Extensions=CSV;',
  'SELECT * FROM data.csv')

Reference

-- Directory: c:\temp
-- Filename: data.csv

SELECT * FROM
OPENROWSET (
  'MSDASQL',
  'Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=c:\temp\;',
  'SELECT * from data.csv');

Reference

Share |
 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.
  • 8494 reads