Import TSV into FoxBase

by

Want to import data from TSV file to FoxBase?

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

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Convert locally and privately, avoid uploading large or private TSV file(s) to online services.
  • Support Windows, Linux, and macOS.

Download Withdata FileToDB Download FileToDB

Import data from TSV file to FoxBase

Login to FoxBase -> Choose TSV file -> Set FoxBase table -> Import TSV to FoxBase

Choose FoxBase and logon.

load TSV data to FoxBase table - Choose FoxBase and logon

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

import TSV data to FoxBase table - task window

Select the “TSV” file type.

Import TSV file data to FoxBase table - select file type

then show the wizard.

1. Open a TSV file.

Support large ( > 4GB ) TSV file.

Import Data From TSV File To FoxBase - open TSV file

Here is the file’s content.

Import Data From TSV File To FoxBase - source TSV file

2. Select a FoxBase table and config fields.

Load Data From TSV File To FoxBase - select table

3. Preview data will be in FoxBase table.

Transfer Data From TSV File To FoxBase - preview

4. Import TSV data to FoxBase.

Import Data From TSV File To FoxBase - import data

View imported data in FoxBase table

Convert TSV to FoxBase - view data

Import TSV to FoxBase in command line

Save “TSV to FoxBase” session, then you can:

Set scheduled tasks for importing TSV to FoxBase

You can schedule and automate this “TSV to FoxBase” conversion task by:

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

FAQ

What is Withdata FileToDB?

How long does it take to import TSV data to FoxBase?

Is it safe to import TSV data to FoxBase using FileToDB?

Can I import TSV data to FoxBase on Linux, Mac OS?

Can I import TSV data to FoxBase in command line?


More about Withdata FileToDB – TSV to FoxBase converter

See also:

TSV → FoxBase reference

Type mapping

Value kindin TSVin FoxBase
Int1234Numeric(10,0)
Bigint9007199254740993Numeric(19,0)
Decimal1234.56Numeric(p,s)
Float1.234e+10Float
Textunquoted; a tab in the value splits the columnCharacter(n)
Long textunquoted; newlines break the rowMemo
Date2026-09-18Date
Datetime2026-09-18 14:30:00(none)
Binarynot representable(none)
BooleanTRUE / FALSELogical
JSONthe whole JSON value as-is (its own quotes stay)(none)

Dialect differences

TSV is a file format and FoxBase 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 TSVin FoxBase
port—(file-based)
identifiersRarely used, which is exactly why tabs in data break it—
row limit—(driver dependent)
datesConventional text: 2026-09-18 or 2026-09-18 14:30:00Date (D)
long text—Memo (M)
binaryNot supported - must be encoded—
separatorTab—
encodingNo declaration - UTF-8 works only with a BOM—
typingNone - every field is text—
shapeFlat table, optional header rowTables of rows and columns
ceilingNo formal limit—

No counterpart

  • TSV values of kind Date and time have nowhere to go in FoxBase.
  • TSV values of kind Binary have nowhere to go in FoxBase.
  • TSV values of kind JSON have nowhere to go in FoxBase.

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.

New to the format? Read what a TSV file is (and how it differs from CSV).