Macro to automatically import data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using an ODBC connection to import data from a UNIX db into Access. Every
time I make changes to the db and want to re-import, I have to select the
connection, choose the tables etc. - time consuming!

Can someone tell me how to write a simple vb script which when run will
automate this process?
 
Steve - that's really helpful, thanks very much.

Is there any way of running all macros in an Access database at the same
time? At the moment I can only run them one by one.
 
Mark,

You can make a separate macro, using a series of RunMacro actions, to
run each of the other macros in one hit... is that what you mean?
 
Sorry, I was being stupid - I've just worked out that you can run multiple
instances of TransferDatabase (or any other action) from within the same
Macro. Thanks for the help.

Mark.
 
Back
Top