SELECT * FROM
OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=E:/;Extensions=CSV;',
'SELECT * FROM book1.CSV')
SQL查询CSV文件方法
最新推荐文章于 2024-05-23 17:52:22 发布
SELECT * FROM
OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=E:/;Extensions=CSV;',
'SELECT * FROM book1.CSV')