Results 1 to 2 of 2
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 7 Access 2000
    Join Date
    Nov 2010
    6 Feet Under

    Append Query to append to a table in different database

    I have 10 databases, each with the exact same query. I am needing to compile this data into excel for a vendor. I was thinking instead of having one massive spreadsheet with 10 individual queries, to run an append query in 9 of those databases and append all records to one "master" table and then from that table run one query!

    My problem, I do not know how to append records to a table in a different database... Can someone please explain how to do this???

    Also, if this is a crazy thought that I have, and there is an easier way to do what I need to accomplish let me know that as well.

    Thanks Guys!!

  2. #2
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    In your "Master" database create your make table query, and go ahead and run that so the table exists. In each of your subsequent databases, open the query in design view, and select an append query, and select the bullet for "Another Database." Enter the full path for this database "N:\Testing\1234\1234.mdb" and then from the drop down menu choose the table name that you are wanting to append to.

    Note: If you entered the path for the source database properly, you will be able to look at all of the tables in the source database from the drop down menu.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database cannot append all the records
    By Paul H in forum Queries
    Replies: 9
    Last Post: 09-19-2011, 02:43 PM
  2. Replies: 7
    Last Post: 07-21-2011, 01:01 PM
  3. Append TABLE
    By BorisGomel in forum Access
    Replies: 6
    Last Post: 05-13-2011, 02:34 PM
  4. Query Table Values in Append Query
    By AKQTS in forum Queries
    Replies: 5
    Last Post: 11-12-2010, 03:58 PM
  5. Append query won't append
    By yelkenli in forum Queries
    Replies: 5
    Last Post: 02-12-2010, 11:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums