Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default odbc connections in excel 2003

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 worksheet connections Eric MacLeod Excel Discussion (Misc queries) 4 June 11th 09 12:45 PM
Managing ODBC connections Danny Excel Discussion (Misc queries) 1 December 4th 07 09:44 PM
An ODBC add-in should be available for Excel 2003 Chris Humphrey Excel Discussion (Misc queries) 1 April 12th 05 02:56 PM
xl odbc driver, Excel 2003 johnny_2005 Setting up and Configuration of Excel 0 February 15th 05 10:08 PM
how can I get odbc plugin for Excel 2003 ? Herve Brelay Excel Discussion (Misc queries) 1 January 30th 05 12:26 AM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"