Importing All Tables From Database A to Database B

[Jesusismygrace]

Good Afternoon,

I hope all is well and holiday joy is shared.

I would like to have my end users import the newly updated tables each month to their front-end database. I have used the TransferDatabase method with some initial success, but there are still few things that I haven't figured out:

1. How to overwrite or delete the existing tables
2. Is there a method to IMPORT ALL the tables from the source database without list them individually?

Thank you for you consideration and time

Yvonne

 

[PHV]

import the newly updated tables each month to their front-end database
Usually a FE has only linked tables ?

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

 

[genomon]

You can manually delete the tables, then use the "select all" option on the import wizard.

Usually a FE has only linked tables ?

Not unless the database is split.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."