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.

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.