Getting data into and out of an OpenOffice.org Base database

The ability to import and export data is crucial to any database management system, and OpenOffice.org Base is no exception. While you may be surprised to discover that OpenOffice.org lacks a dedicated import/export feature, it does allow you to get data into and out of a database in a variety of ways.

Let's start with the most simple scenario, where you have data in a Calc spreadsheet and you want to import it into a new table in a Base database. Before you begin, make sure that the first row in the spreadsheet contains column labels. They will be used as database field names, thus making it easier to manage data during the import process. Copy all the data in the spreadsheet using the Ctrl-A and Ctrl-C keyboard shortcuts (or choose Edit -> Select All and Edit -> Copy).