Create Button Code to Import Table

[Frank Wagner]

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

 

[Ofer]

Try this code under the button

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

 

[Frank Wagner]

Thanks for the CLEAR example. It works fine.