Importing and copying tables?

[Jo Siffert]

Hi all,

is there any programmatic way to
- import (instead of link) a table from an external MDB file including
all schema definitions?
- copy a TableDef?

Thanks a lot for your help,
Jo

 

[Guest]

hi,
i do this all the time with a macro that uses the
transferdatabase method.
the vb line would look like this:

DoCmd.TransferDatabase acImport, "Microsoft Access"," & _
""z:\your\file\path\xxx.mdb", acTable, "sourcetable"," & _
""destinationtable", False

note:false to import table stucture and date
true to import table sturcture only.