Convert DBF to SQLITE

Turn DBF documents into SQLITE. A SQLite database with one table named data, with the field names as column names and the columns typed from the values.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop DBF files on the dialor turn it to pick what to do

A DBF table as a SQLite database.One table named data, with your field names as columns.

  1. What you get

    A SQLite database in one file. It holds a single table named data. The field names of the DBF table become the column names, and each column is typed from the values it holds.

  2. How text is read

    Text is decoded with the code page the DBF file names. When the file names none, it is read as Western European.

  3. What does not carry over

    Some FoxPro fields have no direct equivalent. Currency, date-time and memo fields come out as an unsupported-field note instead of their values. Double fields come out as 0.

    If you need to go the other way, SQLITE to DBF turns a SQLite database back into a DBF table.

DBF and SQLITE.What each format is.

The formats

From · DBF

dBase Table

dBase tables, the attribute tables of shapefiles and many legacy databases.

Extensions
.dbf
MIME type
application/x-dbf
Kind
Documents
To · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data

In your code.The same DBF to SQLITE conversion through the API, for your app or your agent.

terminal
$ cv convert sheet.dbf sheet.sqlite
$ cv convert sheet.dbf sheet.sqlite

Questions.What people ask about DBF to SQLITE.

01OF 04

It is called data. The file holds only that one table.

The column names are the field names from the DBF file. The types come from the values in each column.

The code page named in the DBF file. If the file names none, it uses Western European.

They come out as an unsupported-field note, and so do date-time fields. Double fields come out as 0.

More conversions.Other ways in and out of DBF and SQLITE.