vba与MySQL交互_用VBA实现excel与access数据库交互

[1.建立一个DataBaseCmd，封装Access，继承IAccess的接口using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.OleDb;u

[作者：iamlaosong    网络应用程序一般有两种结构形式，就是所谓的C/S结构和B/S结构，通过Excel和数据库的配合，可以实现简单C/S结构的应用程序，客户端只要安装数据库客

1、将access中数据导入excel

Public Sub ImportData()

Dim mydata As String, mytable As String, SQL As String

Dim cnn As ADODB.Connection

Dim rs As ADODB.Recordset

ActiveSheet.Cells.Clear

mydata = ThisWorkbook.Path & "\成绩管理.mdb" '指定数据库

mytable = "考试成绩" '指定数据表

'建立与数据库的连接

Set cnn = New ADODB.Connection

With cnn

.Provider = "microsoft.jet.oledb.4.0"

.Open mydata

End With

SQL = "select 班级,avg(数学) as 数学平均,avg(语文) as 语文平均," _

& "avg(物理) as 物理平均,avg(化学) as 化