Excel Query Via Sybase

[Gary]

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.

 

[Frank Kabel]

Hi
in Sybase create a query/view which just returns your desired value and
use this view as source for MS Query