Select * from OpenRowset ('MSDASQL',

'Driver= {Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\Import;

Extended properties='';ColNameHeader=True;Format=CSVDelimited'

,'select * from sample.csv')

/* -- one difference delimited with ,

files in same dir

sample.csv

col1,col2,col3

1,a,abc

2,sfasf,sdgagas

schema.ini

[sample.csv]

Format=Delimited(,)

ColNameHeader=True

MaxScanRows=0

Col1= COL1 text Width 30

Col2=...