Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,486

    Why not have the Excel spreadsheet linked directly to Access as a separate Table. Then in a query you can join it to what ever other data you have. The excel file does not need to be open for this type of set up.

    https://support.microsoft.com/en-us/...d-e084913cc958

  2. #17
    samsquared is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    May 2021
    Location
    St. Augustine, FL
    Posts
    8
    I can't get the Michael Saunders method to work presumably because I'm using Excel 2010 (it says 2013 and above). So, I went to the Google sheet to add some stocks. I see them in the Excel spreadsheet, but my linked Access table now just has #ERROR in each cell. I tried to re-link the spreadsheet but am getting a message saying "the connection for viewing your linked microsoft excel worksheet was lost" and so far I've been unable to fix that.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 04-02-2019, 06:45 AM
  2. Market Data Retrieval
    By Grefcon901 in forum Access
    Replies: 16
    Last Post: 04-07-2016, 01:59 PM
  3. Replies: 22
    Last Post: 12-20-2015, 02:46 AM
  4. Replies: 1
    Last Post: 07-11-2012, 01:42 PM
  5. Calculating Current Stock in Inventory/Warehouse
    By yohansetiawan in forum Access
    Replies: 5
    Last Post: 03-14-2012, 09:05 PM

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 - Senior Forums