macro connect to Sage DSN

[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

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

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/vba/adodao/index.php

http://support.microsoft.com/default.aspx?scid=kb;en-us;244761&Product=xlw
XL2000: How to Use ADO to Return Data to a ListBox or ComboBox