Inserting Data

  • Thread starter Thread starter Debbie
  • Start date Start date
D

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)
 
Debbie said:
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)
Click to expand...

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
 
Back
Top