SQL语句选择电子表格 2012.10.23

use aspnetdb
go

exec sp_configure 'show advanced options',1  
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
go

insert into [数据表](字段1,字段2)
select 字段1,字段2 from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=E:\excel表.xls',sheet1$)
go