Inserting Data

[Debbie]

Is there an easy way to insert all data from an old database into a
new database if the data requested is not equal to the old information
(field names)

 

[Larry Linson]

Is there an easy way to insert all data from an old database into a
new database if the data requested is not equal to the old information
(field names)

Surely, on the Database window, use File | Get External Data... to import
the Table from the Old Database and change the names. If you already have
the new Table, create an Append Query to add the old data.

If there are complicating issues, as I suspect there are, post back here and
someone will try to help.

Larry Linson
Microsoft Access MVP