VBA学习课程

Day29 - ADO数据库连接

今日学习目标

• 了解ADO基本概念
• 学会连接Access数据库
• 掌握数据查询操作

知识点

### ADO对象
``vba
Dim conn As Object
Set conn = CreateObject("ADODB.Connection")
conn.ConnectionString = "..."
conn.Open
``

今日代码

Dim conn As Object
Set conn = CreateObject("ADODB.Connection")

conn.ConnectionString = "..."
conn.Open