Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gary
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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
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
New web query with Excel Pro Edition 2003 Chandler Links and Linking in Excel 2 December 15th 04 07:03 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:47 AM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 06:45 AM
Excel user desires to learn ABC of Access Hari Excel Discussion (Misc queries) 1 December 3rd 04 03:32 AM
open saved query in Excel 2003 jaylou Excel Discussion (Misc queries) 1 November 29th 04 07:41 PM


All times are GMT +1. The time now is 11:46 AM.

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

About Us

"It's about Microsoft Excel"