/text/scalc/guide/dbase_files.xhp UFI: new guide asked by users dedr: reviewed exporting;spreadsheets to dBase importing;dBase files dBase;importing and exporting files spreadsheets; importing dBase files spreadsheets; exporting to dBase files database tables;importing dBase files Importing and Exporting dBase Files You can open and save data in the dBase file format (*.dbf file extension) in $[officename] Base or a spreadsheet. A dBase database is directory that contains a collection of 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 %PRODUCTNAME. 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 %PRODUCTNAME Base database table is actually a link to an existing database. Choose File - New - Database. 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. A link to the dBase file is added as a table to the Insight database. To view the table, click the Tables icon in the Database column of the Insight window, and double click the name of the table. If you edit the table in Insight, the changes are saved to the original dBase file. 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 Export. Only the data on the current sheet is exported.