系统: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
field1 = '籍贯 text(10)'
field2 = '语文成绩 single'
'增加字段
SQL = 'ALTER TABLE ' & tblName & ' ADD ' & field1 & ',' & field2
Set rs = cnn.Execute(SQL)
'补充记录
stuName = '张三'
jiGuan = '广东省'
yuWenNote = 85
newXueHao = 1
SQL = 'Update ' & tblName & ' SET ' _
& '籍贯=' & Chr(39) & jiGuan & Chr(39) _
& ',语文成绩=' & yuWenNote _
& ',学号=' & newXueHao _
& ' where 姓名=' & Chr(39) & stuName & Chr(39)
Set rs = cnn.Execute(SQL)
cnn.Close
Set rs = Nothing
Set cnn = Nothing
End Sub Part 3:部分代码解读
Access/VBA/Excel-Access记录创建-04 Access/VBA/Excel-Access表及字段创建-03 Access/VBA/Excel-新建Access文件-02 小结:对数据库的操作转化为对应的 以上为本次的学习内容,下回见 |
|