Results 1 to 3 of 3
  1. #1
    mikem is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    19

    Using Excel RTD to import data into Access

    I have an Excel spreadsheet that I use to track stock trades and am able to use the Excel RTD function to get live prices from my ThinkOrSwim platform
    I need to switch to Access to better manage the data in my trades.
    Any ideas how I can use the Excel functionality to update the fields in my Access database?
    In a perfect world, I would have a CurrentPrice field that auto updated using RTD. Then when I enter a date in to a CloseDate filed (after I close the trade) it would stop updating.
    Any help is appreciated


    thanks
    mike

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Have you considered building your table in Excel and linking that table to Access. Each time your Excel table is updated, it will automatically update to Access.

    https://www.youtube.com/watch?v=oiLMfKyavEU

  3. #3
    mikem is offline Novice
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    19
    thanks. that worked.
    but i had to create a 2 way link.
    first i add a new stock to Access
    then the spreadsheet updates with the new stock
    then the database updates with the price feed.

    they made it so easy in excel, i was hoping for something similar in access

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

Similar Threads

  1. Replies: 2
    Last Post: 01-12-2017, 10:35 AM
  2. Replies: 6
    Last Post: 07-31-2014, 12:53 PM
  3. Import access query data into excel file, using excel vba
    By exceljockey in forum Import/Export Data
    Replies: 3
    Last Post: 11-15-2013, 02:36 PM
  4. Trying to import data into access from excel
    By Cupps256 in forum Access
    Replies: 10
    Last Post: 03-09-2013, 02:31 AM
  5. Import Data from Excel into Access
    By sauce1979 in forum Import/Export Data
    Replies: 2
    Last Post: 10-14-2011, 12:05 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