Mass Merge of a Table

[aaronmib]

I have a table with 45 fields and 900 records and a majority of the information has changed.

I have a complete file in excel with all of the past information and current information merged together.

If I try to break the relationships in the database import the excel file and recreate the links, I can get everything working properly except for the ID field. I cannot change it back to AUTO NUMBER? Any ideas on how to best approach this?

 

[BBQ Kittens]

Alright, this is possible because I have had to do this many times. you need to construct the access table in excel first, ie the excel columns data must reflect the same order as the access field columns. for the autonumber in excel simply generate an autonumbering for that column, ie =B1 +1. once your data is organized properly in excel and the fields are in the appropriate columns to match your access table format, select all your data in excel and ctrl+c and then in access ctrl+a then ctrl+p. This will replace your existing data, assuming it is properly organized, and the autonumber will work.