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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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?
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.
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.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.