Batch import data from multiple HTML files to a single FoxBase table

Want to batch import data from HTML files to FoxBase?

Try Withdata FileToDB, a HTML file to FoxBase converter for Windows, MacOS, and Linux, Easy and Fast.

Download Withdata FileToDB Download FileToDB

Batch import data from HTML files to FoxBase

Choose FoxBase and logon.

convert HTML file to FoxBase table - Choose FoxBase and logon

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

convert HTML file to FoxBase table - task window

Select the “HTML” file type.

Import file data to FoxBase table - select file type

then show the wizard.

1. Select a folder that constains HTML files.

Batch import HTML files data To FoxBase - select a folder

2. Config first HTML file importing options.

Batch import HTML files data To FoxBase - config first file

3. Select a FoxBase table and config fields.

Bulk load HTML files data To FoxBase - select table

4. Preview data.

Batch transfer HTML files data To FoxBase - preview

5. Import HTML files to the FoxBase table.

Batch copy HTML files data To FoxBase - import data

View imported data

Batch copy HTML files data To FoxBase - view data


More about HTML file to FoxBase converter

HTML → FoxBase reference

Type mapping

Value kindin HTMLin FoxBase
Int<td>1234</td>Numeric(10,0)
Bigint<td>9007199254740993</td>Numeric(19,0)
Decimal<td>1234.56</td>Numeric(p,s)
Float<td>1.234e+10</td>Float
Text<td>text</td>Character(n)
Long text<td>multi-line text</td> (entities for &amp; &lt;)Memo
Date<td>2026-09-18</td>Date
Datetime<td>2026-09-18 14:30:00</td>(none)
Binarynot representable in a cell(none)
Boolean<td>true</td>Logical
JSON<td>{&quot;a&quot;:1}</td> (quotes escaped)(none)

Dialect differences

HTML 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 HTMLin FoxBase
port—(file-based)
identifiersAttribute values in quotes; entities for reserved characters—
row limit—(driver dependent)
datesWhatever text was renderedDate (D)
long text—Memo (M)
binarydata: URIs inside src attributes—
separatorTags, not delimiters—
encodingDeclared in a meta charset tag or the HTTP header—
typingNone—
shapeFree form; tables are row/column structures inside markupTables of rows and columns
ceilingNo formal limit—

No counterpart

  • HTML values of kind Date and time have nowhere to go in FoxBase.
  • HTML values of kind Binary have nowhere to go in FoxBase.
  • HTML 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.


Posted

in

by

Tags: