SELECT *
into xlstest4
FROM openrowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database='D:\data\050826.xls;hdr=no',
[report$]
)
into xlstest4
FROM openrowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database='D:\data\050826.xls;hdr=no',
[report$]
)
1. hdr=no
2. 两边加"[""]"
FROM openrowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\data\050826.xls;hdr=no',
'select top 10 * from [sheet1$]'
)上面是只导10行,且含第一行。
FROM openrowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\data\050826.xls;hdr=no',
'select top 10 * from [report$]'
)上面是只导10行,且含第一行。
FROM openrowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\data\050826.xls;hdr=no',
'select top 10 * from [report$]'
)上面是只导10行,且含第一行。
不行啊!
into xlstest4
FROM openrowset(
'Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database='D:\data\050826.xls;hdr=no',
[repor t$]
)
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' does not contain table 're port$'.