i have an access db with identical fields (name, address, etc). there is one table for each letter of the alphabet with each group of names in it. there is an automatic id number primary key in each table. unfortunately they all start at 2. there are over 100k records i'm guessing. this data was imported from excel worksheets. when i imported this to access, i tried to get it all in the same table but it didn't work.
-is there any way to merge all the tables into one? how?
-do i have to reassign the primary key in order for this to not throw up on itself? how?
thanks for any help, i'm new to access, that class 7 years ago doesn't really count.