select * from openrowset('microsoft.jet.oledb.4.0','excel 8.0;hdr=yes;database=d:\test.xls','select a,b,c from [Sheet1$]')--orselect * from openrowset('microsoft.jet.oledb.4.0','excel 8.0;hdr=yes;database=d:\test.xls',Sheet1$)
select * from openrowset('microsoft.jet.oledb.4.0','excel 8.0;hdr=yes;ime=1;database=d:\test.xls','select * from [Sheet1$]')
from openrowset('microsoft.jet.oledb.4.0','excel 8.0;hdr=yes;database=d:\test.xls','select a,b,c from [Sheet1$]')--orselect *
from openrowset('microsoft.jet.oledb.4.0','excel 8.0;hdr=yes;database=d:\test.xls',Sheet1$)
from openrowset('microsoft.jet.oledb.4.0','excel 8.0;hdr=yes;ime=1;database=d:\test.xls','select * from [Sheet1$]')