22,210
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO NewTable
SELECT * FROM OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)};
DEFAULTDIR=E:\2012-09-07\;
Extensions=CSV;','SELECT * FROM ExportData.csv')
sp_configure 'show advanced options',1
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries',1
GO
RECONFIGURE
GO
SELECT * FROM OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.txt; *.csv)};
DBQ=E:\2012-09-07','SELECT * FROM ExportData.csv')