On Error GoTo lbSource
Dim sqlstr As String
Set mConn = New Connection
mConn.Open "provider=SQLOLEDB;server=tsy;uid=sa;password=tongshiyong;database=vms"
sqlstr = "Insert Into temp"
sqlstr = "select * from OpenDataSource('Microsoft.Jet.OLEDB.4.0'," & _
"'Data Source=c:\test.xls;uid=;Password=;Extended properties=Excel 5.0')...sheet1$"
mConn.Execute sqlstrMsgBox "date lead to success!", vbOKOnly, App.TitleExit Sub
lbSource:
MsgBox Err.Description, vbCritical, CStr(Err.Number)这段程序用来实现从Excel表格里的数据导入到SQL server 数据库中的temp表里
但是运行时出现如下错误: 未找到provider=Microsoft.Jet.OLEDB.4.0的注册表项!!!
Dim sqlstr As String
Set mConn = New Connection
mConn.Open "provider=SQLOLEDB;server=tsy;uid=sa;password=tongshiyong;database=vms"
sqlstr = "Insert Into temp"
sqlstr = "select * from OpenDataSource('Microsoft.Jet.OLEDB.4.0'," & _
"'Data Source=c:\test.xls;uid=;Password=;Extended properties=Excel 5.0')...sheet1$"
mConn.Execute sqlstrMsgBox "date lead to success!", vbOKOnly, App.TitleExit Sub
lbSource:
MsgBox Err.Description, vbCritical, CStr(Err.Number)这段程序用来实现从Excel表格里的数据导入到SQL server 数据库中的temp表里
但是运行时出现如下错误: 未找到provider=Microsoft.Jet.OLEDB.4.0的注册表项!!!
解决方案 »
- textbox控件的keypress和keydown事件无法捕捉到tab键,怎么回事?
- 有啥免费好用的表格控件?
- 关于登陆框问题的提问
- VB读写Excel的问题。把数组数据赋值给excel的时候循环速度太慢,一秒大概填20个格,请教
- 谁有 VideoEdit Pro ActiveX Control v1.2
- Active上做的菜单如果在设计时显示?
- 如可将全角的数字转为半角的?
- 请教datacombo控件问题!
- 如何读取WORD中的内容的每一行,写入数据库中
- 如何让MeidaPlayer控件支持所有版本的MediaPlayer
- 请教各位大哥大姐用vb如何做证券市场中的k线图?(讨论)
- 为什么IE按钮不能打开程序???先用1分作信号,100分为能解决问题或者参与的您准备。
2,你的sqlstr有问题吧,
sqlstr= "SELECT * into [youtable]
FROM OpenDataSource
('Microsoft.Jet.OLEDB.4.0','Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...sheet1$"