Dim XL As Excel.Application
Dim xlb As Excel.Workbook
Set XL = New Excel.Application
XL.Workbooks.Open "c:\dt.xls"
Set xlb = XL.Workbooks(1)
XL.Visible = True
Dim cnn As New ADODB.Connection
Dim rs As ADODB.Recordset
If rs.State <> 0 Then
rs.Close
End If
Set rs = New ADODB.Recordset
rs.Open "select * from Student_xx", cnn, adOpenKeyset, adLockOptimistic
If rs.EOF Then
MsgBox "open table failed!"
Exit Sub
End If
rs.AddNew
rs.Fields("学籍号") = XL.Cells(2, 2)
rs.Update
上面是我导入的代码,可是总提示“对象变量或WITH块没有设置”请高手指教,谢谢。
Dim xlb As Excel.Workbook
Set XL = New Excel.Application
XL.Workbooks.Open "c:\dt.xls"
Set xlb = XL.Workbooks(1)
XL.Visible = True
Dim cnn As New ADODB.Connection
Dim rs As ADODB.Recordset
If rs.State <> 0 Then
rs.Close
End If
Set rs = New ADODB.Recordset
rs.Open "select * from Student_xx", cnn, adOpenKeyset, adLockOptimistic
If rs.EOF Then
MsgBox "open table failed!"
Exit Sub
End If
rs.AddNew
rs.Fields("学籍号") = XL.Cells(2, 2)
rs.Update
上面是我导入的代码,可是总提示“对象变量或WITH块没有设置”请高手指教,谢谢。
解决方案 »
- 如何将这个最大的ID号值传递给一个VB6变量:“select max(ID号) from questions GROUP BY 用户名”
- 求企业群发短信的实施方案,请有经验的大侠帮忙,谢绝广告.
- 如何实现控件透明
- 请问在vb的DataReport控件中,如何动态定义多个RptTextBox和RptLabel控件?
- VB读写数据库速度如何?为什么我的这么慢..比ASP慢多了....
- 请问,我想把WORD文档存放在数据库中!!!
- 四舍五入问题请教高手!!!!
- 想用回车键代替鼠标点击cmdOK键
- 关于DataReport
- 如何取得printer支持的顏色數?????
- 在Excel中怎样用VBA显示1选定的某以单元格
- 怎样对二维数组进行初始化?
If rs.State <> 0 Then
rs.Close
End If
Set rs = New ADODB.Recordset
改成 Dim rs As New ADODB.Recordset
If rs.State <> 0 Then
rs.Close
End If