Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a question about Excel 2003. I am a programmer but have never used
Excel for any programming unitl now. (Note the people who setup these spreadsheets, are long gone). I have a workbook that has two tabs on it. I know that there is some of a connection made a sql server 2000 database and there must be a query to obtain the infomation that updates the excel 2003 spreadsheet. I know this happens since I need to hit the 'update option' for each chart on these tabs. Now the problem is that there is some kind of a problem, and I need to be able to solve problems. Ths can you tell me what I need to do in excel 2003 to determine where the data is coming from and how the data is obtained. There must be some kind of a query that is written. I have figured out that if you click on the 'data' on the menu bar, then import external data, then import data, and then click data sources this will give you some kind of a default. If does not show where the data is obtained from and query is used to populate the excel sheet. Thanks fo your assistance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 worksheet connections | Excel Discussion (Misc queries) | |||
Managing ODBC connections | Excel Discussion (Misc queries) | |||
An ODBC add-in should be available for Excel 2003 | Excel Discussion (Misc queries) | |||
xl odbc driver, Excel 2003 | Setting up and Configuration of Excel | |||
how can I get odbc plugin for Excel 2003 ? | Excel Discussion (Misc queries) |