Of course if you mean without putting the data in the spread sheet, then you
can use ADO.

To find connection strings:

http://www.able-consulting.com/ADO_Conn.htm

you probably want

ODBC DSN
File DSN

some information on ADO

http://www.erlandsendata.no/english/...odao/index.php

http://support.microsoft.com/default...61&Product=xlw
XL2000: How to Use ADO to Return Data to a ListBox or ComboBox

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