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
Append multiple tables (1 Viewer)
- Thread starter MsfStl
- Start date
- Local time
- Today, 14:00
- Joined
- Jul 9, 2003
- Messages
- 16,287
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>>>
<<<Example here>>>
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 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
- Local time
- Today, 14:00
- Joined
- Jul 9, 2003
- Messages
- 16,287
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.
Therefore you will have to open the program and set up the references before it will work.