Create Button Code to Import Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to add a button to an Access 2000 form with the VBA code behind
it to import a table from another Access 2000 database. My plan is to use
this to import a data table from a previous version of the application when a
new version is installed.

Any help would be appreciated
 
Try this code under the button

Docmd.TransferDatabase acImport, "Microsoft Access", "c:\DataBaseName.Mdb",
acTable, "TableSourceName","TableDestinationName"
 
Back
Top