“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…”