Running Append/Update Queries (1 Viewer)

Marbinski

Registered User.
Local time
Today, 15:23
Joined
Aug 24, 2004
Messages
45
I currently have a macro that does a process of of appending and updating data from table to table. This macro works on the click of a button. Can someone help me with creating VB Code to run these queries without having to use macros?

Generic field names would work fine to translate to my database.

Run an append Qry:
Run an update Qry:
Open Import Wizard:

This would greatly help my database!! Thanks for any help offered.
 
Local time
Today, 15:23
Joined
Aug 2, 2004
Messages
272
wizard ??

Why not just use the Access wizard to convert your macros to VBA.

On the Tools menu under macros, then convert.

HTH :cool:
 

Users who are viewing this thread

Top Bottom