ado建立表 Option ExplicitPublic Sub NewTable() Dim tbl As New Table Dim cat As New ADOX.Catalog cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"tbl.Name = "WorkTable"tbl.Columns.Append "序号", adInteger tbl.Columns.Append "姓名", adVarWChar, 10 cat.Tables.Append tbl End SubPrivate Sub Form_Load() Call NewTable End Sub对于指向问题也就是access的关系,自行在数据库中间控制就可以了
Option ExplicitPublic Sub NewTable()
Dim tbl As New Table
Dim cat As New ADOX.Catalog
cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"tbl.Name = "WorkTable"tbl.Columns.Append "序号", adInteger
tbl.Columns.Append "姓名", adVarWChar, 10
cat.Tables.Append tbl
End SubPrivate Sub Form_Load()
Call NewTable
End Sub对于指向问题也就是access的关系,自行在数据库中间控制就可以了
price 需要 货币类型,如何写?
:)