I am trying to create a query that ultimately merges two identical databases. I have twenty unique tables and would am trying to create an append query. Is it possible to have one SQL statement where I append each table either all at once or in order? Any thoughts and or examples? Thanks- Scot

what I get from your post is that all your tables are different. So this may not be of any use to you. It is an example database I built in answer to a previous post. It is for appending databases with exactly the same structure.

<<<Example here>>> (http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=6532)

Hi Uncle Gizmo,

I am interested in yor sample database you provided in this post, but after downloading it, I try to open it and get error message "uncrecognized database format". I am using Access 97.

Can you post another version for me to download...if you have one.
Do you know if this one is corrupt?

Thanks,
BJS

I have attached and access 97 version, I cannot load it into access 97 , as I do not have access 97!

Therefore you will have to open the program and set up the references before it will work.