OPENROWSET访问CSV格式文件
OPENROWSET访问CSV格式文件
以下示例访问 D:\ 下的 book1.CSV
SELECT * FROM
OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=D:\;Extensions=CSV;',
'SELECT * FROM book1.CSV')
OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=D:\;Extensions=CSV;',
'SELECT * FROM book1.CSV')