Sorry to push my question. I guess this is not possible? Or have I not
explained properly? Does anyone get spreadsheet data from a database?
> 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