How do in use macros in access to create relationships?

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

Guest

I desire to import a table from another database, and repeat the process but
maintain relationships with other tables in the receiving database.
 
What I normally do is delete the contents of the table and leave the table
structure, then I import into the existing table:


Action: RunSQL
SQL Statement: DELETE * FROM Table1

Action: TransferSpreadsheet (Or whatever you are importing)
Table Name: Table1
 
Back
Top