Macro to automatically import data

[Mark Perry]

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 Schapel]

Mark,

Have a look at the TransferDatabase macro action.

 

[Mark Perry]

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.

 

[Steve Schapel]

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?

 

[Mark Perry]

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.