Dim Excel_Dsn As String Dim Excel_Conn As New ADODB.Connection
Dim Excel_Adodc As New ADODB.Recordset
Dim mySql As String
Dim rs_str As String
Dim FilePath As String
FilePath = App.Path & "\aaa\" & Date & ".xls"
Excel_Dsn = "DRIVER={Microsoft Excel Driver (*.xls)};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=""" & FilePath & """;DBQ=" & FilePath
Excel_Conn.Open Excel_Dsn
mySql = "select * from [test$] where 网址='" & url & "'"
Excel_Adodc.Open mySql, Excel_Conn, adOpenKeyset, adLockPessimistic
以上代码在第一次打开VB工程时调试运行时会出现 ODBC驱动程序不支持的属性错误。改成
Excel_Adodc.Open mySql, Excel_Conn, 2, adLockPessimistic则是不支持的排序,有没有办法解决?
Dim Excel_Adodc As New ADODB.Recordset
Dim mySql As String
Dim rs_str As String
Dim FilePath As String
FilePath = App.Path & "\aaa\" & Date & ".xls"
Excel_Dsn = "DRIVER={Microsoft Excel Driver (*.xls)};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=""" & FilePath & """;DBQ=" & FilePath
Excel_Conn.Open Excel_Dsn
mySql = "select * from [test$] where 网址='" & url & "'"
Excel_Adodc.Open mySql, Excel_Conn, adOpenKeyset, adLockPessimistic
以上代码在第一次打开VB工程时调试运行时会出现 ODBC驱动程序不支持的属性错误。改成
Excel_Adodc.Open mySql, Excel_Conn, 2, adLockPessimistic则是不支持的排序,有没有办法解决?
解决方案 »
- 问一个mshflex
- 请问如何将COMMAND按扭变成椭圆的?还有就是窗体左上角的小图标是哪里改的,谢谢
- OpenResultset是什么属性的。
- 关于几个API函数的简单问题!
- VB求学,求教程推荐。
- 本人已将问题“一个简单而让人困惑的问题(100分送完为止)”中的IP地址更改为109.0.01.1(其他任何一个普通的IP地址也可),请登陆此问题
- 好消息!专业版进销存VB源码(免费试用版下载ftp://telon:[email protected]/)
- 如何判断程序进入Winsock_DataArrival事件?
- 用VB增加记录前做判断的请教
- 对象类型的公共变量如何定义
- 关于VBS脚本的一个问题.
- 自动触发查询按钮,在线等待,很急!
im Excel_Dsn As String
Dim Excel_Conn As New ADODB.Connection
Dim Excel_Adodc As New ADODB.Recordset
Dim mySql As String
Dim rs_str As String
Dim FilePath As String
FilePath = App.Path & "\aaa\" & Date & ".xls"Excel_Dsn = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & FilePath & ";Extended Properties='Excel 8.0;HDR=Yes'"
Excel_Conn.Open Excel_Dsn
mySql = "select * from [test$] where 网址='" & url & "'"
Excel_Adodc.Open mySql, Excel_Conn, adOpenKeyset, adLockPessimistic
Private Sub Command1_Click()
'access导出到excel
Dim db As New ADODB.Connection
Dim sPath As String
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Temp\Test\db1.mdb Persist Security Info=False"
sPath = App.Path + "\backup.xls"
If Dir(sPath) <> "" Then
Kill sPath
Else
Call db.Execute("select * into Sheet1 In '" & sPath & "' 'excel 8.0;' from 表1")
MsgBox "导出成功", vbOKOnly, "提示"
End If
db.Close
Set db = Nothing
End SubPrivate Sub Command2_Click()
'从excel导出到 access
Dim db As New ADODB.Connection
Dim sPath As String
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Temp\Test\db1.mdb;Persist Security Info=False"
sPath = App.Path + "\backup.xls"
Call db.Execute("select * into Table4 From [Sheet1$] In '" & sPath & "' 'excel 8.0;'")
db.Close
Set db = Nothing
End Sub