macro connect to Sage DSN

  • Thread starter Thread starter SW
  • Start date Start date
S

SW

Is it possible to connect to external date via an ODBC DSN. I want to
retrieve some Sage Accounts data into Excel using VBA instead of using the
Query wizard.

Thanks
Steve
 
Turn on the macro recorder and use the query wizard (data=>Get External
Data). That should give you the specific code you need.
 
Back
Top