Basically I知 pretty new to Access, but feel confident for this project it痴 the best solution. Here is essentially what I知 going to try to get done, does using Access make sense for a project like this? Or am I totally off base?

Everyday, I知 going to be downloading basic information on the futures market on a variety of futures, getting the information isn稚 the issue. The issue becomes storing that information over time, the amount of lines in Excel will limit my abilities to keep this information. I知 thinking about getting the information in Excel, then everyday write VBA code to dump that information into an existing Access table that will accumulate over time, possibly years. For example, say I知 getting a snap shot of twenty futures with some information every 20mins, you can see that each day the line items might get long, I just want to take that information and put it somewhere for storage.

The other aspect is, I would like to query those tables for information, and even produce graphs. Does Access have the ability to do graphing? Or would I then take the query data and dump it back into Excel for its graphing abilities? Also, is it possible in Access to have a field in the table do a calculation? Such as a ratio of one field to another field, this too would need to be done so not sure if I知 on the right track.

Any guidance would be helpful, as I have not started this project yet, but just want to get come clarity from people more familiar with Access.