Run ODBC from Macro

  • Thread starter Thread starter Gerrym
  • Start date Start date
G

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.
 
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.
 
Back
Top