Avatar of alevin16
alevin16Flag for United States of America asked on

Can Access track stocks like Excel does?

I see that Microsoft Excel has a feature where you can track your stocks.  Does Microsoft Access have a similar feature?  I am trying to create a program in Access for a user who currently uses Excel to track stocks.  I thought about linking an excel table to access but I do not want him to have to maintain an excel spreadsheet and an access program

MicrosoftMicrosoft ExcelMicrosoft AccessMicrosoft Office

Avatar of undefined
Last Comment
ste5an

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
ste5an

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Peter Chan

Hi,
You can have Access form with the proper codes to track the details of your stocks. Access is giving us good database approach in comparison with Excel file/worksheets. We can also use the similar VBA codes (same as Excel macro), on Access forms.



ASKER
alevin16

Hello ste5an, Thank you for the link.  This is all new to me, is a Data Service something that I subscribe to from a site and they give me the connection string or is it something else?
ste5an

You need to build a XML file which tells Access where to download the data from (web service).

When the data is not available as web service, the depending on their terms of use use MSXML2.XmlHttp in VBA or use curl or wget on the command line to get the data.

Caveat: All these options depends on the license terms of the site.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy