All good information. Please try to ensure that the users group is included on any replies to make sure as many people as possible get this information.
/paul On 10/28/05, Gert Blij <[EMAIL PROTECTED]> wrote: > > On 10/26/05, Nicholas Sushkin <[EMAIL PROTECTED]> wrote: > > I set up a JDBC query in the Base application, but I can't get the > > data out to a spreadsheet. Cut and paste doesn't work. There is no > > option to save the results either. Am I missing something? > > How do I do this? > > Subject to you having "registered" the database when you created it, in Calc > press F4 to see your data sources, select the database, then select the > query. You will see the query results on the right side of the data source > pane above the sheet. Ctl-A and drag and drop from the results pane to the > left, top cell where you want the data to start in your sheet. Voila. > > It gets better the other way around. Say you have a spread sheet that you > want to import as a table in a database. Open both the spread sheet and the > database. Ctl-A the sheet, put your cursor anywhere in the highlighted area, > drag and drop the content on the Table icon in the Base window. I just love > this feature. > > Cheers > Gert > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
