Where possible the utility to issue DML commands directly to HSQLDB, this should yield the best performance to writing a text file as. This page will report on the efforts to implement just this using OOBasic. Information on this activity, including the specification document, can be obtained from the Database project at the main web site, or HSQL Text Table Integration.Īdding a GUI to this inherent support should be a task well suited to the scripting capability built into Base. This feature is being actively developed for a future release. Base at the moment, Release 2.0.4 and earlier, has not GUI interface to this functionality. The HSQLDB database manager employed by as the default database format offers another even more direct path. If, after you select the file, no sheets appear you probably selected an invalid file type (not a spreadsheet, for example).Creating an export utility for embedded Base databasesĬurrently Base has no built in support for exporting data except to other documents.Īn indirect path to exporting data that is commonly used to to first drag a table or a query to Calc sheet. Click Browse and select the file a list of the available sheets appears in the box. On the Insert Sheet dialog, you can also add a sheet from a different spreadsheet file (for example, another Calc or Excel spreadsheet), by choosing the From file option. Repeat steps 1–4 for each new sheet, giving them the names Credit Card 2 and Car Loan.In the Name box, type a name for this new sheet, for example Credit Card 1.In the Insert Sheet dialog, choose the position for the first new sheet.
Rename the existing sheets Summary, Checking Account, and Savings Account, as described in “Renaming sheets” below.To insert sheets and name them at the same time: For the next steps, go to “Renaming sheets” below.(Three sheets are already provided by default.) Because you are inserting more than one sheet, the Name box is not available. In the Insert Sheet dialog, choose the position for the new sheets (in this example, we use After current sheet).We have two choices: insert 3 new sheets and rename all 6 sheets afterwards or rename the existing sheets, then insert the three new sheets 1 at a time, renaming each new sheet during the insert step. We also want to name each of these sheets for the account they represent: Summary, Checking Account, Savings Account, Credit Card 1, Credit Card 2, and Car Loan. We need 6 sheets, one for each of the 5 accounts and one as a summary sheet so we will add 3 more.
0 kommentar(er)
