Appending Access data from regularly updated Excel data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently using Excel's MSN Money plug-in to retrieve stock price
information daily into a spreadsheet. On one worksheet I keep updating and
adding to the data and on another I do various calculations based on the
data. Because the quantity of historical prices is getting rather large I
have begun investigating whether it would be possible to output the striclty
raw price information to an Access database while continuing to do my
calculations within Excel. The questions are these:

Can I keep using the Excel MSN Money plug-in to retrieve the price data each
day and then append that data to an ever growing Access database of price
history? Or is there a way to retrieve the price data directly into Access?
And then can I direct my Excel formulas to query the Access data to calculate
my results?

Thank you for any insight you can provide.
 
I do not know if there is a Money plug-in for Access and the one for Excel
will not be able to pull the data directly into Access; however, what you are
trying to do is definitely feasible. It will take some moderate knowledge of
Access.

There are several ways for Access and Excel to share data. Which you use
depends on the situation. First, you can import Excel data into Access
tables. There is an Action (TransferSpreadsheet) that does that. Once you
have the data in Access, there are several ways you can work with it from
Excel.

One is to export a subset of the data that you want to work with from Access
to Excel. Another is to use MSQuery in Excel which will attach to an Access
database. You can also connect Excel directly to an Access database.

If you are not experienced with Access, I suggest you seek some assistance
with designing your environment and getting it set up.

Good Luck
 
Back
Top