Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to connect Sage line 50 v12 with Excel 2007 | Excel Discussion (Misc queries) | |||
how do i connect to Sage Line 50 v12 from Excel 2007? | Excel Discussion (Misc queries) | |||
how to view sage tool bar | Excel Worksheet Functions | |||
Macro to connect excel sheets automatically to Hyperion ESSBASE 6.5 | Excel Programming | |||
Adding buttons and connect macro | Excel Programming |