Importing data from multiple tables

[Chad1984]

What's the best way to import data from 3-12 tables into a database? I read the help on the import command and the transferdatabase macro action. One problem I have is that I don't just want to import one table, but many. The other problem is that the tables already exist. I can erase all existing data easily enough, but is there a way to just update the existing tables, rather than find a way to drop almost all the tables in the database and import them manually (through the menu command) or one at a time programmatically?

 

[maxhugen]

How about the linking the tables from the second database, then using Update queries?

You could then create a function that automatically runs all the Update queries.

Max Hugen
Australia