UC知道MSFlexGrid与adodc的问题
来源：百度知道 编辑：UC知道 时间：2024/06/07 19:34:46
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=E:\工艺过程卡片\ls_process.xls;Extended Properties=Excel 8.0;"
.Open
End With
Adodc1.RecordSource = "select * from sheet1"
Adodc1.Refresh
Set MSFlexGrid1.DataSource = Adodc1
运行的时候提示“操作已被取消”什么问题
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=E:\工艺过程卡片\ls_process.xls;Extended Properties=Excel 8.0;"
.Open
End With
Adodc1.RecordSource = "select * from sheet1"
Adodc1.Refresh
Set MSFlexGrid1.DataSource = Adodc1
运行的时候提示“操作已被取消”什么问题
Set MSFlexGrid1.DataSource = Adodc1
这一句下面应该还有一句！这只是绑定了一个控键，没有连接到查询到的表！
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "Data Source=E:\工艺过程卡片\ls_process.xls;Extended Properties=Excel 8.0;"
.Open
在连接好以后！open 前面还有一句！去网上查吧！