macro connect to Sage DSN
 

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

macro connect to Sage DSN
 

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

macro connect to Sage DSN
 

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