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.

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

On the Tools menu under macros, then convert.

HTH :cool: