I disagree with a lot of what Trevor said. I don't like using Access forms
and reporting facilities, and Excel is anything but limited (pivot tables,
charts, conditional formatting, data validation, etc., etc?)

What Access does give you is a relational database, which can be very useful
in helping to describe the data and the relationships of that data. You can
actually create Access database even if you don't have Access, as Access is
really two products, the database and the Access reporting and data entry
facility. Creating an Access database, you can then use Excel to analyse
that data.

The advantage over CSV files? All the data in one place. Greater cross file
analysis. Data integrity. And so on.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
...
On Dec 14, 2:47 pm, AMDiesen
wrote:
I currently program using VBA in excel. All the input and output data
created is stored in csv files. The bulk of the inputs are price files
dating back 30 years and updated daily. This data is then manipulated in
countless ways and the output is stored in multiple files in multiple
directories. What would be the value of using access to store the input
and
output files? Thank you for your time.

Hi AMDiesen,
Access is a relational database. It allows data to be linked (i.e.
can build data relationships) easily and have built-in data integrity
check. It comes with query tools to extract and manupilate the data
and reporting tools to generate print reports. I would use Access if I
have to create multi-dimensional queries and create multiple reports.
Provided I don't have too many complex calculations with the data. You
can easily create Data Input forms (similar to UserForms in Excel)
from the defined data tables and/or queries. Excel is a great tool
for calculations but rather limited (other than through VBA
programming) when it comes to extracting and handling multi-
dimensional data. However, Access is bundled with MS Office
professional.

Regards
trevosef