系统:Windows 10
今日歌曲: Part 1:目标
结果如下 Part 2:代码Sub test()
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim SQL As String
Dim tblName
Dim dbAddr
dbAddr = ThisWorkbook.Path & '\学生信息.accdb'
tblName = '学生信息表'
'连接数据库
With cnn
.Provider = 'Microsoft.ACE.OLEDB.12.0'
.Open 'Data Source=' & dbAddr
End With
'记录1
stuName = '张三'
stuNum = 11
stuGender = '男'
SQL = 'INSERT INTO ' & tblName & ' (姓名,学号,性别) VALUES' _
& '(' & Chr(39) & stuName & Chr(39) & ',' & stuNum & ',' & Chr(39) & stuGender & Chr(39) & ')'
Set rs = cnn.Execute(SQL)
'记录2
stuName = '李四'
stuNum = 12
stuGender = '男'
SQL = 'INSERT INTO ' & tblName & ' (姓名,学号,性别) VALUES' _
& '(' & Chr(39) & stuName & Chr(39) & ',' & stuNum & ',' & Chr(39) & stuGender & Chr(39) & ')'
Set rs = cnn.Execute(SQL)
cnn.Close
Set rs = Nothing
Set cnn = Nothing
End Sub Part 3:部分代码解读
Access/VBA/Excel-新建Access文件-02 Access/VBA/Excel-Access表及字段创建-03 小结:对数据库的操作转化为对应的
以上为本次的学习内容,下回见 |
|