用select * from openrowset()提示from 子语法错误
select * FROM openrowset('Microsoft.Jet.OLEDB.4.0','excel 8.0;Database=c:\book1.xls',[sheet1$])是为什么
[解决办法]
--在外围应用配置器中功能的应用里打开即席远程查询.
select a,b
from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="d:\book2.XLS";Extended Properties="Excel 8.0";Persist Security Info=False')...[sheet1$]
[解决办法]
Dim cn As ADODB.Connection, rs As ADODB.Recordset
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\book1.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
Set rs = New ADODB.Recordset
rs.Open "select * FROM [Sheet1$]"
[解决办法]
biaoji
[解决办法]
select * from [excel 8.0;database=c:\book1.xls].[sheet1$]
就成功了
