这样试试
select * from openrowset('microsoft.jet.oledb.4.0','excel 8.0; HDR=Yes;IMEX=1;database=c:\book1.xls','select * from [sheet1$]')
select * from openrowset('microsoft.jet.oledb.4.0','excel 8.0; HDR=Yes;IMEX=1;database=c:\book1.xls','select * from [sheet1$]')
select *
from OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=yes;imex=1;DATABASE=c:\book1.xls',sheet1$)
顺便问一句,使用OpenDataSource的应该怎样写?
from openrowset('microsoft.jet.oledb.4.0','excel 5.0;hdr=yes;imex=1;database=c:\book1.xls',sheet1$)
select *
from opendatasource('microsoft.jet.oledb.4.0','excel 5.0;hdr=yes;imex=1;database=c:\book1.xls')...[sheet1$]