exporting records in multiple table databases

[jjwiet]

Hello,

I use access 2003 and attempting to export/copy records between two access databases (almost identical) with multiple tables (both databases having the same relations between the tables).
I have no problems exporting records with an addition query for a single table into a singel table of the other database.
However, i would like to create a function to export the records in one go from the multiple tables in the first database to the multiple tables in the second.
I tried combining SQL of the single addition queries as well as creating a macro, but it doesn't work.

This exporting of records has to be done repeatedly an manual because of privacy affairs.

Tnx in advance

[DonRayner]

Here is an example of how you could step through the tables in your database and using the table name run a specific sql statement.

Dim tbl As TableDef, stSQL as string
Dim db As DAO.Database
Set db = CurrentDb()
For Each tbl In db.TableDefs
    SelectCase tbl.name
    Case is = "Table1"
        stSQL = "Enter Your SQL Here"
    Case is = "Table2"
        stSQL = "Enter Your SQL Here"
 
    Continue Cases with all your table names here
 
    End Select
    DoCmd.RunSql stSQL
Next tbl

[NeoPa]

You could set up a FrontEnd (FE) database that used both of the other databases as BackEnds (BEs).

This FE would copy from one to the other using simple SQL (QueryDefs whatever). You could even link a whole bunch of them together in sequence very similarly to how Don has already illustrated.

Welcome to Bytes!