Question about updating tables in Access 2000

[bacon333]

Alright I have two databases with the same name "Lamination"

Access 2000:
M:\lamination.mdb

Access 98:
N:\lamination.mdb

The table list:
local tables:
Schedule
Production
(There are 15 more local tables)

linked tables:
Prices (linked Access table)
Cofire (foxpro linked table)

Ok, now I relinked all the linked Access and Foxpro tables in the Access 2000 database.

All I need to do is update all the information from the Access 98 local tables to all the local tables in Access 2000 and ignore the linked ones.

What's the easiest way to do this?

 

[KLin]

It's actually Access 97(from office97 ). Anyways, from within the access 2000 application, do this:

1. Click File
2. Click Get External Data
3. Click Import
4. choose the access97 database file.
5. Select each table you want to import.

 

[bacon333]

Let me rephrase, what's the easiest way to automate this process? Macros? VB code?

I have about 25 Access 2000 databases that need to be updated with all the data within the 25 Access 97 databases (except linked tables).