Query Data from 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.

 

[David Seeto via AccessMonster.com]

Hi Gary,

You should probably ask this question in an MS Excel forum - this one is for MS Access, the database product.