Skip to main content

Using SQL to query a CSV file


Using SQL to query a CSV file


SELECT * FROM OPENROWSET ( BULK 'csv file name' , DATA_SOURCE = 'DataLake' , FORMATFILE='formatfile.fmt' , FORMATFILE_DATA_SOURCE = 'DataLake' ) AS x

Comments

Popular posts from this blog