Excel - dynamic ODBC query to a sybase DB

[Stefan Joest]

Hello,

I created an Excel workbook which retrieves Data through ODBC from a
Sybase Dababase. I can retrieve actual data by clicking on the
exclamation mark in the External Data- Toolbar (I don't know if this
is the exact name - I have a german excel version!).

What I would like to know is: How can I design the query so that it
behaves dynamically?

For example- I have a date field in my Excel workbook and when I click
on the exclamation mark, I want the query to retrieve all orders from
the Sybase DB from that date. Or- another example- I create a dialog
box which asks the user for his name and then the query retrieves all
records from the database the user created.

One more question: Is there a way to see the query somewhere in Excel
(in the Visual Basic editor?) or is it just possible to see and modify
it in MS Query?

Please help me- this is really important for me!

Thank you,

Siegfried

 

[Jamie Collins]

(e-mail address removed) (Stefan Joest) wrote ...

I created an Excel workbook which retrieves Data through ODBC from a
Sybase Dababase. I can retrieve actual data by clicking on the
exclamation mark in the External Data- Toolbar (I don't know if this
is the exact name - I have a german excel version!).

What I would like to know is: How can I design the query so that it
behaves dynamically?

For example- I have a date field in my Excel workbook and when I click
on the exclamation mark, I want the query to retrieve all orders from
the Sybase DB from that date. Or- another example- I create a dialog
box which asks the user for his name and then the query retrieves all
records from the database the user created.

Take a look at Dick Kusleika's site e.g.

http://www.dicks-clicks.com/excel/ExternalData6.htm#Parameters

Jamie.

--