I’d appreciate any advice on the problem I’ve been struggling with the last few days.
The small place of business where I work has a database in Access 2000. At some point a separate table was created for information on clients from one of the three municipalities we serve.
I’ve made sure both tables have all the same fields, in the same order. I probably need to go through again to make sure length and data type match in all instances.
A bigger problem (I think) is that both have autonumber fields, both starting at 1.
What’s the easiest way to merge these tables? I’ve seen references to Append Queries and conflicting information on Paste Appending. So far none of my experiments have been successful, but I’m not sure what I’m doing wrong, or even which approach I should be focusing on.
