Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Unanswered: Combining two tables into one table - exceeded Excel rows

    Hi guys,

    first time poster here. I wanna ask how to combine two tables into one table in access as I have exceeded the limit in Excel 2010.

    Table 1:

    ID Name Hobby Religion
    1 Tom Basketball Christian
    2 James Basketball Christian
    3 Rich Basketball Christian

    Table 2:

    ID Name Hobby Religion
    1 Kila Basketball Muslim
    2 Royce Basketball Muslim
    3 Rich Basketball Muslim

    Desired Outcome:

    ID Name Hobby Religion
    1 Tom Basketball Christian
    2 James Basketball Christian
    3 Rich Basketball Christian
    4 Kila Basketball Muslim
    5 Royce Basketball Muslim
    6 Rich Basketball Muslim

    Thanks guys

  2. #2
    Join Date
    Mar 2012
    Posts
    3
    I would upload the first set of information into Access and setup the table as you need.

    Then Append the second set of information into the table that you just setup.

Posting Permissions

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