Copying records to a new table

[citygov]

I am trying to help a new employee with an MS Access 2000 problem. The db was created years ago, and the main table (permits) needed some major changes. She created a new db with a table that has all the same fields as the old db, but many new ones as well. We want to now import the data from the old db's "Permit" table to the new db's "Permit" table. All the field names are correct, but we keep getting errors trying to import and export. There are approximately 940 records.

Is there an easy way to do this? Thank you!

Mike

 

[tjs206]

I assume you are trying to import the table?

Why not import the table and let Access create a new table, name it whatever you want and then add the new fields to the new table.

If you don't want to do that. Ensure that the field types are identical to the table that you are trying to import from. For example: autonumber, number = number, etc.

Try that to see if it works.