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

--
Regards,
Tom Ogilvy


"SW" wrote in message
...
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