Run ODBC from Macro

[Gerrym]

Can I execute an ODBC connection to a SYBASE database and
extract data from one table using a macro. I do not want
to LINK the database as I only want to extract from sybase
and not update sybase.
I can do this manually but would like to automate it.

 

[Douglas J. Steele]

The TransferDatabase action should do what you want. Of course, I would
think that it would better to use VBA than a macro for something like this,
so that you can put in error checking.