Hamish wrote:
HelloHi Hamish, yes, the best place to ask is on the list. It is very likely that an email sent directly to an individual will not receive the attention that it deserves, and it may be ignored entirely, purposely or otherwise. I receive a couple hunderd email messages every day that I try to at least take a quick look at them.... Also, you are not likely to receive all of the replies, so be certain to monitor the mailing list for replies.
I have been told that this may be the correct place to ask for this
answer. I am not a subscriber, so please reply to me as well!
On Mon, 2005-03-14 at 22:42 +0000, CPH wrote:
Hello everyone I would like to convert some ms spreadsheets to OOo, but I am having problems with one point: The spreadsheets get their information from an ODBC query, and can be updated for the latest data. Paramaters for the queries (like from_date etc) can be prompted for, but I want the parameters to come from the spreadsheet. ie Query is {SELECT * FROM foo WHERE bar = ?} then I want it to get the value of ? from a cell on the spreadsheet. It prompts for parameters at the moment, but i want to be able to fetch them from a spreadsheet cell instead. Hope I have explained clearly! Thanks, H
Hi Hamish,
Not sure if you still have this problem, but you may want to ask on [email protected] for more help.
Thanks!
Hamish
Did you want to tie your select statement to the cell, or did you want to write a macro that enters the values into the query? I doubt if you can tie the values together. I expect that you will need to write a macro to manipulate the query.
-- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm Free Info: http://www.pitonyak.org/oo.php
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
