Importing and Exporting dBase Files
You can open and save data in the dBase file format (*.dbf file extension) in LibreOffice Base or a spreadsheet. In LibreOffice Base, a dBase database is a folder that contains files with the .dbf file extension. Each file corresponds to a table in the database. Formulas and formatting are lost when you open and save a dBase file from LibreOffice.
To Import a dBase File Into a Spreadsheet
-
Choose File - Open.
-
Locate the *.dbf file that you want to import.
-
Click Open.
The Import dBase files dialog opens.
-
Click OK.
The dBase file opens as a new Calc spreadsheet.
If you want to save the spreadsheet as a dBase file, do not alter or delete the first row in the imported file. This row contains information that is required by a dBase database.
To Import a dBase File Into a Database Table
A LibreOffice Base database table is actually a link to an existing database.
-
Choose
. -
In the File name box of the Save As dialog, enter a name for the database.
-
Click Save.
-
In the Database type box of the Database Properties dialog, select "dBASE".
-
Click Next.
-
Click Browse.
-
Locate the directory that contains the dBase file, and click OK.
-
Click Create.
To Export a Spreadsheet to a dBase File
-
Choose File - Export.
-
In the File format box, select "dBase file".
-
In the File name box, type a name for the dBase file.
-
Click Save.
Only the data on the current sheet is exported.