.mdb.access数据库VBA-利用Access对象在已有的数据库中创建数据表 |
时间:2025-01-20 08:52:44 来源: 作者: |
利用Access对象在已有的数据库中创建数据表 xe5检测VBA 代码:与1-8不同处加注释,其它相同xe5检测VBA Public Sub1_9()xe5检测VBA Dim appAccess As Access.Applicationxe5检测VBA Dim dbs As Objectxe5检测VBA Dim myTbl As Objectxe5检测VBA Dim myFld As Variantxe5检测VBA Dim myData As Stringxe5检测VBA Dim myTable As Stringxe5检测VBA myData = ThisWorkbook.Path & "\学生成绩管理.mdb"xe5检测VBA myTable = "期末成绩"xe5检测VBA Set appAccess = New Access.Applicationxe5检测VBA ‘打开一个现有的Access数据库xe5检测VBA appAccess.OpenCurrentDatabase myDataxe5检测VBA Set dbs = appAccess.CurrentDbxe5检测VBA ‘删除数据库中已经存在的同名数据表xe5检测VBA dbs.TableDefs.Delete myTablexe5检测VBA Set myTbl = dbs.CreateTableDef(myTable)xe5检测VBA Set myFld = myTbl.CreateField("学号", DB_Text, 10)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("姓名", DB_Text, 6)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("性别", DB_Text, 1)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("班级", DB_Text, 10)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("数学", DB_SINGLE)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("语文", DB_SINGLE)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("物理", DB_SINGLE)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("化学", DB_SINGLE)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("英语", DB_SINGLE)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA Set myFld = myTbl.CreateField("总分", DB_SINGLE)xe5检测VBA myTbl.Fields.Append myFldxe5检测VBA dbs.TableDefs.Append myTblxe5检测VBA appAccess.Quitxe5检测VBA Set appAccess = Nothingxe5检测VBA Set dbs = Nothingxe5检测VBA Set myTbl = Nothingxe5检测VBA Set myFld = Nothingxe5检测VBA MsgBox "数据表<" & myTable & ">创建成功!", _xe5检测VBA vbOKOnly + vbInformation, "创建数据表"xe5检测VBA End Subxe5检测VBA
扩展:appaccess.opencurrentdatabase mydata, ,”12345” ‘打开带有密码的数据表xe5检测VBA |
|
|
|