Withdata Software

xBase import multiple TXT (semicolon delimited text) files into a single table

Want to import multiple TXT (“;” semicolon delimited text) files into a single xBase table?

Try Withdata FileToDB, a desktop TXT to xBase converter for Windows, MacOS, and Linux, Convert TXT to xBase, Easy and Fast.

Download FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import multiple TXT (“;” semicolon delimited text) files into a single xBase table

Login to xBase -> Choose TXT files -> Set xBase table -> Import TXT files to xBase table

Choose xBase and logon.

Click “Wizard – N Files To 1 Table” at task dialog.

Select the “TXT” file type.

then show the wizard.

1. Select a folder that constains TXT (“;” semicolon delimited text) files.

Support large ( > 4GB ) TXT (“;” semicolon delimited text) files.

2. Config first TXT (“;” semicolon delimited text) file importing options.

3. Select a xBase table and config fields.

4. Preview data will be in xBase table.

5. Import multiple TXT (“;” semicolon delimited text) files to the xBase table.

View imported data in xBase table

Import multiple TXT (“;” semicolon delimited text) files to xBase in command line

Save “multiple TXT (“;” semicolon delimited text) files to xBase” session, then you can:

Set scheduled tasks for importing multiple TXT (“;” semicolon delimited text) files to xBase

You can schedule and automate this converting task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “TXT to xBase” conversion.
  2. Set scheduled task for “TXT to xBase” conversion.

FAQ

What is Withdata FileToDB?
Withdata FileToDB is an ETL software can import TXT (“;” semicolon delimited text) data to xBase. Download Withdata FileToDB
How long does it take to import TXT (“;” semicolon delimited text) data to xBase?
FileToDB works fast. It convert millions of rows within a minute.
Is it safe to import TXT (“;” semicolon delimited text) data to xBase using FileToDB?
Of course! FileToDB import TXT (“;” semicolon delimited text) data to xBase locally, absolutely safe.
Can I import TXT (“;” semicolon delimited text) data to xBase on Linux, Mac OS?
Yes, you can. FileToDB has Linux, Mac OS, and Windows version.
Can I import TXT (“;” semicolon delimited text) data to xBase in command line?
Yes, you can. FileToDB can running in command line, on Linux, Mac OS, and Windows.


More about Withdata FileToDB – TXT (“;” semicolon delimited text) to xBase converter

See also:

Semicolon-delimited text → xBase reference

Type mapping

Value kindin Semicolon-delimited textin xBase
Int1234Numeric(10,0)
Bigint9007199254740993Numeric(19,0)
Decimal1234.56Numeric(p,s)
Float1.234e+10Float
Textquoted only when it contains a semicolon or a quoteCharacter(n)
Long textmust be quoted; line breaks inside force multi-line recordsMemo
Date2026-09-18Date
Datetime2026-09-18 14:30:00(none)
Binarynot representable - base64 or hex string(none)
BooleanTRUE / FALSE, or 1 / 0 depending on the writerLogical
JSONthe whole JSON value quoted, with internal quotes doubled(none)

Dialect differences

Semicolon-delimited text is a file format and xBase is a database server, so the target has to be told the types the file never carried - the rows below are where the two sides diverge.

Propertyin Semicolon-delimited textin xBase
port—(file-based)
identifiersDouble quotes; a literal quote is doubled ("" )—
row limit—(driver dependent)
datesDates often use D/M/Y or D.M.Y in European exportsDate (D)
long text—Memo (M)
binaryNot supported—
separatorSemicolon ";"—
encodingOften ANSI or Latin-1 in European exports; UTF-8 needs a BOM—
typingNone - every field is text—
shapeFlat table, optional header rowTables of rows and columns
ceilingNo formal limit; row count bounded by memory—

No counterpart

  • Semicolon-delimited text values of kind Date and time have nowhere to go in xBase.
  • Semicolon-delimited text values of kind Binary have nowhere to go in xBase.
  • Semicolon-delimited text values of kind JSON have nowhere to go in xBase.

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.