Importing and copying tables?

  • Thread starter Thread starter Jo Siffert
  • Start date Start date
J

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
 
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.
 
Back
Top