Private Sub Command3_Click()
'On Error GoTo 111
Dim i As Long
Dim SQLSTR As String
Dim mysheet As Worksheet
Set Cnn = New ADODB.Connection
Cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=costf-gb04年新料价.xls;Extended Properties='Excel 8.0;HDR=Yes'" Cnn.Open
SQLSTR = "select * from [sheet1$]"
Set Rss = New ADODB.Recordset With Rss
.ActiveConnection = Cnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockBatchOptimistic
.Open SQLSTR
End With
'Exit Sub
'111:
'MsgBox Err.Description
End Sub运行时提示错误:“MICROSOFT JET数据库引擎找不到'sheet1$',请确认对象是否存在,并正确的写出它的名称和路径” (EXCEL文件中存在sheet1这个表),请问各位错在那里?应怎么修改?
'On Error GoTo 111
Dim i As Long
Dim SQLSTR As String
Dim mysheet As Worksheet
Set Cnn = New ADODB.Connection
Cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=costf-gb04年新料价.xls;Extended Properties='Excel 8.0;HDR=Yes'" Cnn.Open
SQLSTR = "select * from [sheet1$]"
Set Rss = New ADODB.Recordset With Rss
.ActiveConnection = Cnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockBatchOptimistic
.Open SQLSTR
End With
'Exit Sub
'111:
'MsgBox Err.Description
End Sub运行时提示错误:“MICROSOFT JET数据库引擎找不到'sheet1$',请确认对象是否存在,并正确的写出它的名称和路径” (EXCEL文件中存在sheet1这个表),请问各位错在那里?应怎么修改?
解决方案 »
- COMM通讯干扰导致软件假死
- 请 问 外 挂 驱 动 是 什 么 ?
- 如何在combobox中,列出A表中的字段值,而更新B表的更一个字段?
- 大量VB+ORACLE的模块开发外包!!!
- 怎样获得鼠标的绝对坐标?
- 怎么在datagrid中更新远程数据库的内容?
- ADO2。0建立临时表是否一定要升级到VB 6.0 SP5?
- 如何使用sendmessage 发送一些组合健信息
- 使用winsock时出现重大问题,请高手指点!
- 在线求助!!如何用VB列出系统中所有的DSN?及编程实现“建一个DSN?”
- 如何将EXCEL的一个SHEET,文本,ACCESS中的一个表,DBF文件等转换成ACCESS数据库中的一个表
- 有点关于水晶报表的问题
'On Error GoTo 111
Dim i As Long
Dim SQLSTR As String
Dim mysheet As Worksheet
Set Cnn = New ADODB.Connection
Cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=false;Data Source=costf-gb04年新料价.xls;Extended Properties='Excel 8.0;HDR=Yes'" Cnn.Open
SQLSTR = "select * from [sheet1$]"
Set Rss = New ADODB.Recordset With Rss
.ActiveConnection = Cnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockBatchOptimistic
.Open SQLSTR
End With
'Exit Sub
'111:
'MsgBox Err.Description
End Sub运行时提示错误:“MICROSOFT JET数据库引擎找不到'sheet1$',请确认对象是否存在,并正确的写出它的名称和路径” (EXCEL文件中存在sheet1这个表),请问各位错在那里?应怎么修改?