Which DBF files does it open?
Visual FoxPro and FoxPro 2 tables, and dBase III and IV tables. A file that is not a DBF table, or is damaged, is reported as such rather than shown empty.
No Visual FoxPro. No ODBC driver. No Windows. The table opens in this browser tab.
A DBF table is often three files with one name. The viewer matches them by name, so pick them in one go:
A .dbc stores persistent relations between its tables. The Diagram tab draws them with each table's primary key; select a table to follow its relations.
What each part of a FoxPro table or database becomes in the viewer:
| In your files | In the viewer |
|---|---|
| Visual FoxPro types | Currency, DateTime, Integer, Double, Varchar, Varbinary, Blob and nullable fields arrive as typed columns. Currency stays exact. |
| Memo files: .fpt, .dbt, .dct | Memo text, and binary memos such as General and Picture fields, load into their columns. |
| Codepage | Taken from the table header, so Cyrillic and Eastern European tables open with the right letters. |
| .dbc database | Long table and field names, primary keys, and the relations, drawn in the Diagram tab. |
| .cdx index | Tag names and expressions in the file panel, primary and candidate keys marked. |
| Deleted rows | Hidden, as FoxPro hides them. The file panel gives their count. |
| .idx, .ntx and .mdx indexes | Not read. |
The file is opened from your disk and read where it sits, so there is no upload and no copy on a server. Queries are read-only, which means the file you opened is the file you still have, and closing the tab leaves nothing behind.
Visual FoxPro and FoxPro 2 tables, and dBase III and IV tables. A file that is not a DBF table, or is damaged, is reported as such rather than shown empty.
The table still opens. Its memo columns are empty, and the viewer names them together with the file it is missing, so you can pick the set again.
The table carries no codepage mark, so it opened as Windows-1252. Pick the right codepage in the file panel and the table is read again.
There is no fixed limit: the tables are held in the tab's memory, so the machine sets the ceiling. Loading shows its progress row by row. An export writes the first 10,000 rows free and the whole result with PRO.
No. The viewer runs SELECT and WITH queries only and never writes to your files.
Need these tables in SQL Server, MySQL, PostgreSQL or SQLite? DBConvert for FoxPro converts .dbc databases and free tables there, and back into FoxPro.
Need help with a file? Contact us