dim db as database
dim tab as tabledef
dim tab1 as tabledef
dim fieldn as field
Dim file_path As String
file_path = App.Path & "\" & "sample.mdb"
Set db = DBEngine.Workspaces(0).OpenDatabase(file_path)
set tab1= db.CreateTableDef("b")
set tab=db.tabledefs("a")
for i=1 to tab.fields.count
set fieldn=tab.fields(i-1)
tab1.fields.append fieldn
next
记得给分哦!!!!!!!^^