VBA vs MS Access.. automation?

A

arian29

In the zone
:arrow:I have lots of data in an excell sheet. I have to do a lot of cleaning and other things before i can analyze it. So i will be automating it to save time. Now i have two options , automate using VBA or using MS Access. Whats better and why ?
 
asingh

asingh

Aspiring Novelist
arian29 said:
:arrow:I have lots of data in an excell sheet. I have to do a lot of cleaning and other things before i can analyze it. So i will be automating it to save time. Now i have two options , automate using VBA or using MS Access. Whats better and why ?
Click to expand...

Depends what you want to do. Things can be automated in Excel also (VBA). Or you can import the data into MS-Access. What will you do after you have achieved the the clean up scrub.

Give me more details here. Have around 9 years of experience doing this. :)
 
You must log in or register to reply here.
Top Bottom