Re: excel VBA programmer, what is the value of adding access for data
- From: trevosef@xxxxxxxxx
- Date: Fri, 14 Dec 2007 01:33:34 -0800 (PST)
On Dec 14, 2:47 pm, AMDiesen <AMDie...@xxxxxxxxxxxxxxxxxxxxxxxxx>
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
.
- Follow-Ups:
- Re: excel VBA programmer, what is the value of adding access for data
- From: Bob Phillips
- Re: excel VBA programmer, what is the value of adding access for data
- Prev by Date: Re: UDF that works under Excel 2003 but not under Excel 2007
- Next by Date: Re: Automation stumble
- Previous by thread: Re: How to ORDERBY Alphabets in ascending order?
- Next by thread: Re: excel VBA programmer, what is the value of adding access for data
- Index(es):
Relevant Pages
|
