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

   1.

      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

1


      4. When it opens, click the Refresh button

      2
      5. Save the changes and close

   1. Getting the data into a text document

      1. Create a new OpenOffice.org Writer text document.2. Choose Vie