Dim dbsNorthwind As Database Dim tdfNew As TableDef Dim fldLoop As Field Dim prpLoop As Property Set dbsNorthwind = OpenDatabase("Northwind.mdb") Set tdfNew = dbsNorthwind.CreateTableDef("NewTableDef")'新建表 With tdfNew ' The CreateField method will set a default Size ' for a new Field object if one is not specified. .Fields.Append .CreateField("TextField", dbText) .Fields.Append .CreateField("IntegerField", dbInteger) .Fields.Append .CreateField("DateField", dbDate) End With dbsNorthwind.TableDefs.Append tdfNew 你为什么不用ado,它比dao有优势 alter table [yourtablename] add column [columnname][your constraints] 这是ado的方法
Dim tdfNew As TableDef
Dim fldLoop As Field
Dim prpLoop As Property
Set dbsNorthwind = OpenDatabase("Northwind.mdb") Set tdfNew = dbsNorthwind.CreateTableDef("NewTableDef")'新建表
With tdfNew
' The CreateField method will set a default Size
' for a new Field object if one is not specified.
.Fields.Append .CreateField("TextField", dbText) .Fields.Append .CreateField("IntegerField", dbInteger)
.Fields.Append .CreateField("DateField", dbDate)
End With dbsNorthwind.TableDefs.Append tdfNew 你为什么不用ado,它比dao有优势
alter table [yourtablename] add column [columnname][your constraints]
这是ado的方法