| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ODBC Data Connection
Hi, when I import external data into excel using the Tools Import
External Data .... function where does excel store this connection? I know it's there because i can right click and 'Refresh Data"..... I would like to access this connection some how but am not sure as how I go about doing so... Regards, jerm |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel ODBC Data Connection
It creates a query table object:
Dim WS As Worksheet Dim QT As QueryTable Dim QTCount As Long For Each WS In ThisWorkbook.Worksheets For Each QT In WS.QueryTables Debug.Print QT.Parent, QT.CommandText QTCount = QTCount + 1 Next Next MsgBox "There are " & QTCount & " query tables in this workbook." NickHK "jerm" wrote in message ups.com... Hi, when I import external data into excel using the Tools Import External Data .... function where does excel store this connection? I know it's there because i can right click and 'Refresh Data"..... I would like to access this connection some how but am not sure as how I go about doing so... Regards, jerm |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel ODBC Data Connection
thanks :)
jer NickHK wrote: It creates a query table object: Dim WS As Worksheet Dim QT As QueryTable Dim QTCount As Long For Each WS In ThisWorkbook.Worksheets For Each QT In WS.QueryTables Debug.Print QT.Parent, QT.CommandText QTCount = QTCount + 1 Next Next MsgBox "There are " & QTCount & " query tables in this workbook." NickHK "jerm" wrote in message ups.com... Hi, when I import external data into excel using the Tools Import External Data .... function where does excel store this connection? I know it's there because i can right click and 'Refresh Data"..... I would like to access this connection some how but am not sure as how I go about doing so... Regards, jerm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel connection to ODBC database | Excel Discussion (Misc queries) | |||
| Changing and Adding data through ODBC connection | Excel Discussion (Misc queries) | |||
| ODBC connection string Excel to AS/400 | Excel Programming | |||
| How to Switch the ODBC connection in Excel | Excel Programming | |||
| Excel / Access ODBC connection | Excel Programming | |||
Linear Mode
