Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Query Via Sybase
Thank you in advance for reading the question.
I am using Excel and am trying query data from a Sybase server using ODBC. I underlying data in months and profit figures by product. The spreadsheet has column A (month) and column B (profits). I am essentially trying to sum up total profits in each month. eg. Jan +800k I tried using Microsoft Query, but am not sure how to have it only return the single total figure rather than a full blown query outoutput. Any suggestions are appreciated. |
#2
|
|||
|
|||
Hi
in Sybase create a query/view which just returns your desired value and use this view as source for MS Query -- Regards Frank Kabel Frankfurt, Germany "Gary" schrieb im Newsbeitrag ... Thank you in advance for reading the question. I am using Excel and am trying query data from a Sybase server using ODBC. I underlying data in months and profit figures by product. The spreadsheet has column A (month) and column B (profits). I am essentially trying to sum up total profits in each month. eg. Jan +800k I tried using Microsoft Query, but am not sure how to have it only return the single total figure rather than a full blown query outoutput. Any suggestions are appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New web query with Excel Pro Edition 2003 | Links and Linking in Excel | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
open saved query in Excel 2003 | Excel Discussion (Misc queries) |