DIGIT-ARC read-only archive · snapshot: July 23, 2026

DIGIT-ARC / Software / Programming

VBA vs MS Access.. automation?

2 posts · originally from https://geek.digit.in/community/threads/vba-vs-ms-access-automation.139813/

A
arian29 Original post #1
Apr 26, 2011 at 6:02 PM
: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 #2
Apr 26, 2011 at 9:10 PM
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. :)