Withdata FileToDB imports fixed-width text files into xBase locally — one file into one table, several files into one table, or bulk import many files into many tables. 100% local, secure, and cross-platform.

Fixed-width text is a plain text format in which every column has a fixed character width and no delimiter is used.

Download Free Trial

Why Choose Withdata FileToDB as the Fixed-Width Text to xBase Importer?

🔒 100% Local & Secure

Your Fixed-Width Text files and xBase credentials are used only on your own computer. Nothing is uploaded to any cloud server.

⚡ Fast Streaming Import

Millions of rows within a minute. Large files are streamed with low memory usage.

📁 Batch & Merge

Import several Fixed-Width Text files into one xBase table, or bulk import a whole folder into many tables.

🔄 Column Widths, No Delimiter

Define the width of every column (N columns need N-1 widths). No delimiter and no quoting are needed.

🗃 6 Load Modes + Auto Create Table

Append, Replace, Update, Upsert, Insert Ignore and Delete. The destination table can be created automatically from the source columns.

⏱ CLI & Scheduled Tasks

Save an import configuration and run it automatically from Windows Task Scheduler or crontab.

Full Feature Comparison

Feature	Supported details
Source file	Local fixed-width text, batch files, merged files
Destination database	xBase (connect with host / port / user / password; SSL where the server supports it)
Load modes	`Append` · `Replace` · `Update` · `Upsert` · `Insert Ignore` · `Delete` — with a multi-column key for Update / Upsert
Import mode	One file into one table · several files into one table · bulk import into many tables
Running mode	GUI wizard · command line · scheduled tasks
Source options	Format-specific parsing for Fixed-Width Text, encoding
Destination options	Schema, table name, create table if missing, column mapping, update key, encoding
Platform	Windows, macOS, Linux (native, 64-bit)

All Fixed-Width Text to xBase Import Options You Need

Import one Fixed-Width Text file into one xBase table — step by step in the GUI wizard
Import several Fixed-Width Text files into a single xBase table
Bulk import many Fixed-Width Text files into many xBase tables
Insert new rows, or Update/Upsert existing rows using a multi-column key
Run the import from the command line, and schedule it as a scheduled task
All Fixed-Width Text tools and all xBase tools

Fixed-Width Text to xBase Import Notes

Columns are defined by widths, not by a delimiter: for N columns you enter N-1 widths, e.g. 10,25,8.
No delimiter and no quoting are used — spaces are part of the column.
A header row is optional and leading rows can be skipped.
The encoding (UTF-8, ANSI, UTF-16, ...) can be detected or set explicitly.
The parsed columns can be mapped to the columns of the destination table.
Six load modes are available: Append (insert all rows), Replace (truncate then insert), Update, Upsert, Insert Ignore and Delete.
Update and Upsert can use a multi-column key to match existing rows.
The destination table can be created automatically from the source columns, or an existing table can be used.
The destination schema and table can be chosen, and source columns can be mapped to table columns.
The file encoding is detected automatically and can be overridden.

How to Import Fixed-Width Text into xBase (4 Steps)

Open Withdata FileToDB and connect to your xBase database (host, port, user, password).
Choose the Fixed-Width Text file to import (or a folder / list of files for batch importing).
Choose the destination schema and table — create it from the source columns if it does not exist — and pick the load mode (Append, Replace, Update, Upsert, Insert Ignore or Delete).
Check the preview and column mapping, then click Import. Save the configuration if you want to run it again from the command line.