ODBC Queries + Cell references

[Phillip Hall]

Hi all,

I am using Excel + ODBC to generate a report from data stored in a
PostgreSQL database. The report is very simple and the SQL to return the
data for the report is also very simple. The SQL only has 2 variable
parameters being dates which need to be changed whenever the report needs
calculating.

There does not seem to be a way to have the ODBC SQL query use a cell
reference for the two date parameters. If there was a way to do this I
would love to now.

Cheers -

Philip

 

[Jim Gordon MVP]

Hi Phillip,

What version of Excel are you using?

-Jim

 

[Phillip Hall]

Hi Jim,


Sorry for the delay in replying. I am using Microsoft Office X with all the
upgrades...

I am hoping that there is an answer to my query...

 

[Jim Gordon MVP]

Hi

You can use VBA for this in Excel 98 and 2001, but that functionality is
part of the "ODBC Add-in" which was included with those products but is not
included in Office X.

Microsoft chose not to update the ODBC Add-In for Office X in part due to
uncertain demand for it (I may have been the only person who requested it).

if you would like this functionality restored, please send a feature request
suggestion to Microsoft requesting that the ODBC add-in be updated for
Office X. You won't get a personal reply, but your request will be tracked
in their database. Here's the URL:
http://www.microsoft.com/mac/feedback/suggestion.asp

You can still create a parameter query using SQL, but it would require the
user to manually input the values into a dialog box prompt.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Before posting a "new" topic please be sure to search Google Groups to see
if your question has already been answered.

An Excel add-in is available to help with this task.
<http://www.rondebruin.nl/Google.htm>

----------