Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Unanswered: Merge Linked Tables?

    I have 15 linked Excel tables in my Access db. The info in these externally linked tables changes daily. The field names in all these tables are identical. Is there a way to merge all these tables into one main internal table? If so, can the main internal table reflect the changes made to the external Excel tables? Thanking you in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by DLA321
    I have 15 linked Excel tables in my Access db. The info in these externally linked tables changes daily. The field names in all these tables are identical. Is there a way to merge all these tables into one main internal table? If so, can the main internal table reflect the changes made to the external Excel tables? Thanking you in advance.
    Hi DLA - welcome to the forum

    I would suggest that you check out UNION queries in Access Help (or on the web).
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •