Results 1 to 4 of 4
  1. #1
    Tibbs is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Dec 2015
    Posts
    4

    Can I link 2 excel files into one Access table

    I have a table in excel that is updated daily - it's possible for old numbers to be revised, so it's important that the data is 'live' so I link to the excel spreadsheet rather than import the data.

    I've now go to the point where I've exceeded the million rows that Excel allows, so want to extend onto another sheet or spreadsheet file.



    Is there a way to link 2 excel table to one access database table?

    If there's a way, that would be amazing!

    Thank you in advance for any help you may have.

    /edit I'm now using Windows 10 and Access 2013

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can link as many XL tables as you want.
    I have 1 XL file with many tabs, all linked in as tables.

    you wouldnt link them in as 1 table, you CAN query them all together as 1 dataset....
    UNION query.

    select * from xlTable1
    union
    select * from xlTable2
    union
    select * from xlTable3

  3. #3
    Tibbs is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2015
    Posts
    4
    That's a great idea, I'll give it a go thank you!

    I've not used programming like that before, so I may be back...

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    its not programming, just a query.
    but youre welcome.

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

Similar Threads

  1. Replies: 4
    Last Post: 07-21-2017, 01:07 PM
  2. Replies: 3
    Last Post: 04-07-2016, 04:36 AM
  3. Browse for excel files and append to Access table.
    By newbieX in forum Programming
    Replies: 5
    Last Post: 01-27-2014, 07:10 PM
  4. Link image files to Access table
    By amerifax in forum Access
    Replies: 12
    Last Post: 07-03-2013, 03:50 AM
  5. Replies: 1
    Last Post: 06-27-2012, 07:39 AM

Tags for this Thread

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