Export Tables

[Steven547]

I want to have a button on my form, that when clicked, will export certain tables in the current database, to a "backup" database. I also would like to rename those files maybe adding the date at the end of the table name, to distinguish between them. How do I do this? I tried the search function in this forum, but I received a "maintence" error.

 

[PHV]

I suppose you ask for VBA in access.
Have a look at the DoCmd.TransferDatabase method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Steven547]

I am looking at that and getting confused on how that would work. Especially if I want to rename the DB so it doesnt get overwritten. I would like to have TableA from C:\Database1 get exported and renamed as TableABackup in C:\DatabaseBackup. Database1 and DatabaseBackup are both Access Databases. The docmd.Transfer isn't working correctly at this point.

 

[PHV]

The docmd.Transfer isn't working correctly at this point
Why not posting what you have tried so far ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886