Fire a MSAccess macro within vb.net?

Q

quahog

Well-known member
Joined
Jul 1, 2003
Messages
69
Location
dc
Does any know how to fire off a MSAccess macro from within vb.net?

I have a data set that needs extensive cleaning, so I perform the cleaning by running several queries inside MSAccess. I have the queries grouped within a macro, which I would like to fire from my vb.net application.

Any help would be greatly appreciated!
 
Set your Access reference and create your access.application object.

There is a method called DoCmd. Im not too familiar with syntax but if you need a quick example i can give you one when I get home.

Let me know
 
Back
Top