Hi all, After doing a bit of research and tinkering, it looks like:
1) The database connection and queries have to be defined in the database file. The database file does not need to be open when using the queries from the spreadsheet. 2) The database (and queries and tables) can be imported into the spreadsheet from the tools->options->database menu Mark On 1/7/06, Mark Greenbank <[EMAIL PROTECTED]> wrote: > > Hi again, > > It seems I can use a data source that has been defined in a database > (.odb) that I have open along with the spreadsheet. Is there any way to add > a database (in OOo 2.0) in a stand-alone spreadsheet? > > Thanks, > Mark > > On 1/5/06, Mark Greenbank <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > Is it possible to display the results of a db query in a calc > > spreadsheet? If so, how? I've looked in the Help -- Is this documented > > somewhere? > > > > Thanks, > > Mark > > > > >
