Not logged in

sqlite3-dbf - converter of XBase / FoxPro tables to SQLite

Debian source and binary packages

Sources for MinGW build Note: MEMO files does not supported because I don't know how to emulate mmap interface for MinGW


SQLiteDBF converts XBase databases, particularly FoxPro tables with memo files, into a SQL dump. It has no dependencies other than standard Unix libraries.

This use codebase of the PgDBF project (http://pgdbf.sourceforge.net/) which designed to be incredibly fast and as efficient as possible.

$ sqlite3-dbf
Usage: sqlite3-dbf [-m memofilename] filename [indexcolumn ...]
Convert the named XBase file into SQLite format

  -h  print this message and exit
  -m  the name of the associated memo file (if necessary)

sqlite3-dbf is copyright 2010 Alexey Pechnikov
Utility based on source code of PgDBF (c) 2009 Daycos
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Report bugs to <pechnikov@mobigroup.ru>


When terminal encoding is same to dBase file encoding the usage is very simple:

sqlite3-dbf test.dbf | sqlite3 test.db

In other causes are needed read the dBase file in his original encoding and convert SQL dump from dBase file encoding into terminal encoding.

Example for Cyrillic dBase files and UTF-8 console encoding:

LANG="ru_RU.CP866" sqlite3-dbf test.dbf | iconv -f cp866 -t utf8 | sqlite3 test.db