After an overwhelming response of the esteemed readers to my post about How to Import Data From Spreadsheet into OpenOffice.org Database, I decided to add a post about exporting the data out of OpenOffice.org Base to a word processor or a spreadsheet application.
What is the need to export the data?
If you are just concerned with entering the data and pop it out in reports then there is no need to do export of the data. But in case (there can be many) you are required to provide your data to someone in a form they can read which is either a spreadsheet or a text file.
So here we go
-
Prepare the data: For those who want to export the complete table itself there is no need to read through this step. But if you need to export only certain records then we need a query or view to restrict the data appropriately.
Once you’ve got a query or view, complete this step to update and make sure your query or view contains the latest data.
1. Open the database file
- 2. Click the Table icon on the left to view the views or the Query Icon to view the queries.3. Double click on the view or the query
4. When it opens, click the Refresh button
5. Save the changes and close
- Getting the data into a text document
- 1. Create a new OpenOffice.org Writer text document.2. Choose View–>Data Sources from the Menu bar.
3. Expand the database and view the table, view or the query to get the data from
4. Click the upper left blank square to select all
5. Click and hold down on the blank square; keep your mouse held down and drag your into the text document and release your mouse.
6. After this the Insert Database columns will appear.
7. Select the required columns and click OK
8. The data will appear.
Exact same procedure can be followed in the case of Spreadsheet application and its left as an exercise for the readers. In case of any sought of doubts or queries do leave a comment.
Filed under: Technical, Tutorials and Problems | Tagged: database, excel, export, openoffice, spreadsheet, tables, text, Writer
[...] can also check out another post on exporting the [...]
Thank you, this was very helpful, saved me a lot of headache.
Many, many thanks. After days of struggling to learn the logic of Base I began to look for how to export it to something useful. WTF, no csv, dbf or anything export! I was about to resurrect good old PCFile from my DOS days till I found this.
Openoffice Base and I still have a ways to go but at least now I can use programs from this millennium.
BED
I found a solution to export big tables from Base to Calc or Writer.
With the `cut and paste` method, my Base crashes on big tables. (96 KB table with 5000 records) With this solution, Base and Calc remain stable
The idea is to first make a Query in Base and then to import this Query in Calc
1. Make Query in Base. Save
2. Open empty calc File
3. Select menu: > View > DataSources
4. Search for the Database and Select your query.
Now Wait for data to load.
Perform the next steps in the upper pane:
5. Press |> button to go to last record of table
Please be patient now! *** This can take more then 30 secs ***
6. Select the last row (click on the grey box with green arrow on left of last row)
THe whole row should be blue now.
7. Hold Shift and Press Home once
Wait for the cursor to go back to the first row (this should only take a few seconds)
All data in the table should now be selected (blue)
You can now import it in you calc file.
8. Press Data to text Button.
The data is now imported in your Calc file (this should only take a few seconds)
9. Save the file.
great job..thanks