在SQL语句select case when end可以在ORCAL中运行。现将SQL语句select case when end引入到VB或EXCEL vba运行不了。问各位大侠,SQL语句select case when end能在EXCEL VBA或VB中运行吗???
在下面任何一种工作环境都行。
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中的MouseUp事件请教
- 奉献出我作后的60分求 不理解的::一个时间段问题?DateADD()所获得时间,如何与表中的字段(时间)做比较,进来都有分
- 更新问题!
- 请教各位高手,如何使其它程序中被设置为enable=false得控件激活?
- 绝望求助中……
- 请问大家, vb 下 使用media player 全屏后如何 获得鼠标点信息呢? 大家新年好
- 急!急!急!急!,有关VB,宽带联接,远程登录是问题??
- 怎么得到子窗口的句柄(知道父窗口的句柄和子窗口的ID ),用哪个API函数
- 如何使安装程序包尽可能的小?
- 如何调用有返回值的函数?
- 要在文本文件中删除指定字符串开头的一行改怎么做?
- Picture.Print Tab
Microsoft.Jet.OLEDB.4.0数据引擎不支持case语句