.FPT

FPT File

FoxPro Table Memo File
Ask a question
QUICK ANSWER

An FPT file is the memo companion to a FoxPro or Visual FoxPro database table (.dbf). It holds the actual content of memo and binary fields that are too large for the fixed-width .dbf record. To open the database correctly, the .fpt file must be in the same folder as the .dbf file with the same base name. Open it with DBF Viewer Plus, Visual FoxPro 9.0, or LibreOffice Base.

Developer: Microsoft (Visual FoxPro); originally Fox Software Category: Database Files Open standard MIME: application/octet-stream
OPENS ON Windows macOS
Related: .DB · .DBF · .ACCDB · .SQL

On this page

19k+ extensions indexed
Last reviewed Aug 30, 2026

Not sure what your file is?

Drop any file into our identifier - we read just the first bytes to name the format.

Identify a file

What is the FPT file format?

An .fpt file is a binary sidecar file paired with a FoxPro database table (.dbf). It stores the content of memo and binary fields that are too large or variable in length to fit within the fixed-width record structure of a .dbf file. Every .fpt shares the same base name as its parent .dbf - for example, customers.dbf and customers.fpt - and the two files must always reside in the same directory.

The format was introduced with FoxPro 1.0 in 1989 by Fox Software and later standardized under Microsoft's Visual FoxPro line. .fpt uses a fixed block structure: a 512-byte header records the block size and the pointer to the next available block, followed by a chain of fixed-size blocks (default 512 bytes) holding individual field values. Each memo entry begins with a 4-byte type flag and a 4-byte length, then the raw data. Text memos end with two 0x1A EOF markers.

Unlike the older .dbt format used by dBASE III/IV, .fpt can store binary objects such as images, OLE objects, and other blobs in addition to plain text. Block size is configurable via the SET BLOCKSIZE command.

Visual FoxPro 9.0 SP2 (2007) was the last version of the platform; Microsoft ended support in January 2015. Legacy .fpt data is typically migrated to modern databases such as SQL Server, SQLite, or PostgreSQL using FoxPro's COPY TO command or third-party conversion tools.

Security & safety

RISK: LOW

Binary data file, not executable. Historical FPT files may contain sensitive legacy business data (customer records, documents). No known malware vector.

Format details

in a nutshell
FULL NAMEFoxPro Table Memo Fileaka Visual FoxPro memo file, xBase FPT memo
DEVELOPERMicrosoft (Visual FoxPro); originally Fox Softwaresince 1989 (FoxPro 1.0 by Fox Software)
MIME TYPEapplication/octet-stream
TYPEBinary sidecar file storing memo/blob fields for a DBF table
STANDARDOpen · royalty-free
This extension is also used by…
  • FileMaker Pro Database Memo File - FileMaker Pro also uses .fpt for its legacy flat-file database memo/container field storage, unrelated to the xBase/FoxPro format.
MAGIC BYTES · FILE SIGNATURE
OFFSET
00010203
HEX
00000001
ASCII
····
Header block (512 bytes): bytes 0-3 = next free block number (big-endian); bytes 4-5 = reserved; bytes 6-7 = block size (big-endian, default 64 = 512 bytes / 8). Block size can be 33-65535 bytes. dBASE IV uses .dbt with a different header; FPT replaces DBT in FoxPro.

Programs that open FPT files

Windows4 apps
DBF Viewer Plus Freemium Open the .dbf file; FPT is loaded automatically from the same folder. Memo fields display in-place.
Visual FoxPro 9.0 Paid USE table.dbf in the Command Window; BROWSE to view records including memo fields.
dBASE Plus Paid Open the .dbf; .fpt memo file is linked automatically.
LibreOffice Base Open-source Connect to the folder as a dBase datasource; memo fields from .fpt are read through the JDBC driver.
macOS1 app
FileMaker Pro (FileMaker variant only) Paid Open the FileMaker .fp7/.fmp12 database file; FPT sidecars are managed automatically by FileMaker.

Technical details

deep spec
File typeBinary sidecar memo and BLOB storage file for dBASE/FoxPro tables
MIME typeapplication/octet-stream
Byte orderbig-endian
Block structureFixed-size blocks; default 512 bytes (block size value 64 × 8); configurable via SET BLOCKSIZE
Block size range33-65,535 bytes per block; default is 512 bytes in Visual FoxPro
Header layout512-byte block 0: bytes 0-3 = next-free-block number; bytes 6-7 = block size (both big-endian)
Memo entry layout4-byte type flag (0 = picture/binary, 1 = text memo) + 4-byte data length + raw data bytes
Text memo terminatorTwo 0x1A (Ctrl-Z) bytes at the end of each text memo entry
Binary data supportStores images, OLE objects, and arbitrary binary BLOBs - unlike dBASE .dbt which is text-only
Pairing requirementAlways paired with a .dbf of the same base name; the .fpt file is never standalone
DBF linkage.dbf stores the FPT block number as a text offset in each memo field slot
Typical file size4 KB - 500 MB (grows with accumulated memo content; reduced by running PACK command)
dBASE equivalent.dbt (dBASE III/IV); FPT and .dbt are not interchangeable despite similar purpose
Last supported platformVisual FoxPro 9.0 SP2; Microsoft ended VFP support in January 2015
Released1989 (FoxPro 1.0 by Fox Software)
Latest versionVisual FoxPro 9.0 SP2 format (2007, last VFP release)
Open standardYes · royalty-free
Specificationlearn.microsoft.com

FPT conversions

Community Q&A

asked by users
Ask a quick question
Get help from people who work with FPT files. Be specific - include your system and software version.
No account needed · answers usually within a day

No questions yet - be the first to ask about FPT files.

Frequently asked questions

What is an FPT file and do I need it?
It is the memo data companion to a FoxPro .dbf table. You need it to see memo and binary fields; without it those fields appear empty.
Can I open FPT files without Visual FoxPro?
Yes - DBF Viewer Plus and LibreOffice Base can read DBF+FPT pairs without installing VFP.
Is Visual FoxPro still supported?
No. Microsoft ended extended support for VFP 9.0 in January 2015. The software still runs on older Windows but receives no updates.
Why does FileMaker also use .fpt?
Coincidence of naming; the FileMaker FPT format is entirely different from the FoxPro FPT format. They are unrelated.
How do I migrate FoxPro FPT data to a modern database?
Use Visual FoxPro's COPY TO command or DBF Viewer Plus to export to CSV/SQL, then import into your target database.

References

1Microsoft Learn - Memo File Structure (.FPT)learn.microsoft.com
2manmrk.net - Xbase FPT format specification (reverse-engineered)manmrk.net

Keep exploring

across the database

Top extensions this week

1.AQQAQQ Instant Messenger File
2.CRDOWNLOADChrome Partial Download File
3.MDMarkdown Document
4.BINCD/DVD Disc Image (BIN/CUE)
5.PARTPartial Download File
6.RPMSGRestricted Permission Message
7.NOMEDIAAndroid No-Media Marker File
8.EXEWindows Executable (Portable Executable)
9.AVIFAV1 Image File Format (AVIF)
10.ICSiCalendar data file

Related extensions

.DBSQLite Database File
.DBFDatabase File (dBASE / xBase table)
.ACCDBMicrosoft Access Database (2007+)
.SQLSQL Script (Structured Query Language source / database dump)
.MDBMicrosoft Access Database (97-2003, Jet engine)
.FDBFirebird Database

Free file tools

An in-browser file identifier and image converter - everything runs on your device.

Open the toolbox

Browse file extensions A-Z