Set conn = CreateObject("ADODB.Connection") 我现在收集到方法有以下三种方法.
请教各位大侠还有其它方法???谢谢。
1、文本 数据库连接
Set conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("adodb.recordset")
conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};DBQ=d:\", "", ""
rs.Open "select * from mmm.txt where aa <> '' ", conn, 1, 3
2、MDB 数据库连接
Private Function CreateConnection(AccessDbName As String) As ADODB.Connection
Dim ConStr As String, Cnn As ADODB.Connection
Set Cnn = New ADODB.Connection
With Cnn
.CursorLocation = adUseClient
.Provider = "Microsoft.Jet.OLEDB.4.0"
ConStr = "Data Source =" & ThisWorkbook.Path & AccessDbName
Cnn.Open ConStr
End With
Debug.Print "Have been Connection " & ThisWorkbook.Path & AccessDbName
Set CreateConnection = Cnn
End Function 3、Excel 数据连接
Dim strSql As String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" & ThisWorkbook.FullName
strSql = "SELECT distinct aa.aa,aa.bb,bb.dd"
strSql = strSql & " FROM [Sheet1$] AS aa "
strSql = strSql & "Inner Join [Sheet2$] as bb On aa.dd =bb.cc"
请教各位大侠还有其它方法???谢谢。
1、文本 数据库连接
Set conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("adodb.recordset")
conn.Open "DRIVER={Microsoft Text Driver (*.txt; *.csv)};DBQ=d:\", "", ""
rs.Open "select * from mmm.txt where aa <> '' ", conn, 1, 3
2、MDB 数据库连接
Private Function CreateConnection(AccessDbName As String) As ADODB.Connection
Dim ConStr As String, Cnn As ADODB.Connection
Set Cnn = New ADODB.Connection
With Cnn
.CursorLocation = adUseClient
.Provider = "Microsoft.Jet.OLEDB.4.0"
ConStr = "Data Source =" & ThisWorkbook.Path & AccessDbName
Cnn.Open ConStr
End With
Debug.Print "Have been Connection " & ThisWorkbook.Path & AccessDbName
Set CreateConnection = Cnn
End Function 3、Excel 数据连接
Dim strSql As String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" & ThisWorkbook.FullName
strSql = "SELECT distinct aa.aa,aa.bb,bb.dd"
strSql = strSql & " FROM [Sheet1$] AS aa "
strSql = strSql & "Inner Join [Sheet2$] as bb On aa.dd =bb.cc"
解决方案 »
- 【求助】VB对象删除出错,各位出招。。。。。
- msgbox框出来以后,如果一定时间内没有人点确定,那怎么让这个框消失,使程序自动运行?
- 求助:MSDN如何使用
- 请问高手如何将以下DAO建库的方法改为ADO的啊!!!
- 这是一个关于用vb处理图象的问题,希望大家赐教。
- 在winodws2000中实现关闭计算机的VB代码是什么?
- TreeView的KeyDown事件中,如何识别 + - * / 号
- 窗口最大化
- :关于ADO和DATEGRID的问题 急
- 如何绘图并保存为PNG文件?
- 发个帖问下,那位有自绘窗体标题栏使得其在失去焦点时看上去仍然保持高亮啊,效果就为photoshop一样。
- 如何将自定义类型保存到字节数组中
MSSQL:Provider=SQLOLEDB.1;Password=MyPassworkd;Persist Security Info=True;User ID=SA;Initial Catalog=MyDataBase;Data Source=ServerIP
Set rs = CreateObject("adodb.recordset")是 VB Script 的写法,常见于动态网页代码。 Dim Cnn As ADODB.Connection
Set Cnn = New ADODB.Connection 是 VB 中建立连接对象的常规做法。 Dim cnn As New ADODB.Connection 是 VB 中的可选用法。它的代价是直至 cnn 实例化之前,会有附加的一句编译后代码反复执行。