|
跨工作薄和工作表的习题。
- Sub ll()
- Dim Cn As ADODB.Connection
- Dim Rs As ADODB.Recordset
- Dim Sql
- Set Cn = New ADODB.Connection
- Set Rs = New Recordset
- Cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0;HDR=yes';data source=" & ThisWorkbook.FullName
- Sql = " select a.学号,b.期中成绩,c.期末 from ([a$]a left join [b$]bon a.学号=b.学号) left join [c$]con a.学号=c.学号"
- Sql = " select a.学号,b.期中成绩 from ([a$]a left join [b$]b on a.学号=b.学号) " 'left join [c$]con a.学号=c.学号"
- Debug.Print Sql
- Sql = "select a.学号,b.期中成绩,c.期末 From ([D:\aaa.xlsm].[a$]a left join [D:\aaa.xlsm].[b$]b on a.学号=b.学号) left join [D:\aaa.xlsm].[c$]c on a.学号=c.学号"
- Debug.Print Sql
- Set Rs = Cn.Execute(Sql)
-
- Sheet4.Cells(2, 10).CopyFromRecordset Rs
- Stop
- End Sub
复制代码
|
|