DBase III

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
(Added link to PHP XBase)
(Additional Weblinks: Deleted links that were moved to DBF)
Line 38: Line 38:
  
 
== Additional Weblinks ==
 
== Additional Weblinks ==
* [http://en.wikipedia.org/wiki/DBase Wikipedia article about dBase]
+
* [[Wikipedia:DBase|Wikipedia article about dBase]]
 
* [http://www.nationalarchives.gov.uk/pronom/x-fmt/9 dBase III entry in PRONOM]
 
* [http://www.nationalarchives.gov.uk/pronom/x-fmt/9 dBase III entry in PRONOM]
 
* [http://www.digitalpreservation.gov/formats/fdd/fdd000325.shtml dBase entry at digitalpreservation.gov]
 
* [http://www.digitalpreservation.gov/formats/fdd/fdd000325.shtml dBase entry at digitalpreservation.gov]
* [http://www.dbf2002.com/dbf-file-format.html DBF File structure]
 
* [http://www.dbase.com/Knowledgebase/INT/db7_file_fmt.htm dBase File Structure at dBase knowledge base]
 
* [http://www.clicketyclick.dk/databases/xbase/format/index.html Xbase file format description]
 
 
* [http://www.dbase.com/ Current dBase product]
 
* [http://www.dbase.com/ Current dBase product]
 
* [http://www.textfiles.com/programming/FORMATS/dbasefil.inf dBase III file structure]
 
* [http://www.textfiles.com/programming/FORMATS/dbasefil.inf dBase III file structure]
 
* [http://stackoverflow.com/questions/14008534/opening-and-searching-dbase-iii-dbf-databases-in-python Opening and searching dBase III (DBF) databases in Python]
 
* [http://stackoverflow.com/questions/14008534/opening-and-searching-dbase-iii-dbf-databases-in-python Opening and searching dBase III (DBF) databases in Python]
* [https://github.com/hisamu/php-xbase PHP XBase - A parser for dbf files using PHP]
+
 
 +
See [[DBF#Links]] for more links related to DBF format.

Revision as of 15:53, 12 March 2016

File Format
Name DBase III
Ontology
Extension(s) .dbf
PRONOM x-fmt/9

dBase III is a database program.

This article describes how to export data out of a dBase III Table File (*.dbf).

Contents

Opening the data with Libre Office

It is possible to import *.dbf files into Libre Office (or Open Office) Calc or Base: http://help.libreoffice.org/Calc/Importing_and_Exporting_dBASE_Files .

Libre Office will try to recognize the character encoding of the data and preselect this option in the import window. Once a file imported, it can be saved in/exported to a variety of different formats.

Importing the data directly into a mySQL database

Alternatively the data can directly be imported into a running mySQL database using the linux program dbf2mysql. Importing the data directly however could cause some problems with the character encoding for non ASCII characters.

If the mysql server is already running, the following commands will import the data:

user@linux:~$ mysql -u root -p
mysql> create database database_name;
mysql> exit
user@linux:~$ sudo apt-get install dbf2mysql
user@linux:~$ dbf2mysql -vvv -c -f -d database_name -U root -P password DATA_FILE.DBF 

The data can then be exported using mysqldump

user@linux:~$ mysqldump -u root -p database_name > data_export.sql

Specifications

Metaformat files

See also

Additional Weblinks

See DBF#Links for more links related to DBF format.

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox