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.
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.
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.
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
dBase Table
dBase tables, the attribute tables of shapefiles and many legacy databases.
- Extensions
- .dbf
- MIME type
- application
/x -dbf - Kind
- Documents
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.
$ cv convert sheet.dbf sheet.sqlite$ cv convert sheet.dbf sheet.sqliteQuestions.What people ask about DBF to SQLITE.
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.