开启Ad Hoc Distributed Queries功能:
USE master
go
EXEC sp_configure 'Ad Hoc Distributed Queries',1
RECONFIGURE;
EXEC sp_configure;
执行数据导入:
SELECT * into [#Temp_Table] FROM
OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="E:\WorkFolder\AutoCRMDoc\Cargigi_NIssan\Car_Gi_Gi__AutoNation_Pilot_Stores_(2)_(2).xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[sheet1$]