Copy table data from one DB to another
Posted on 2006-05-18
I have a problem, and am wondering if any advice.
I have a lot of data on several tables in one DB. I need to copy the date (including AutoNumbers) to a different data base with similar styles but not identical. When I am trying this now, the AutoNumber field doesn't stay the way it was on the original table; as expected it continues in numerical order in the new table. I need to keep the data because other tables contain relationed data to all of the auto's. Please help!