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 ' )