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]
