Withdata Software

Import each table data in a HTML file to a separate FoxPro table

Want to import data from each table in a HTML file to a separate FoxPro table?

Try Withdata FileToDB, a HTML to FoxPro converter, Import each table data in a HTML file to a separate FoxPro table, Easy and Fast.

Download Withdata 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 data from each table in a HTML file to a separate FoxPro table

Select tables in HTML file -> Set FoxPro tables -> Import HTML data to FoxPro

Choose FoxPro and logon.

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

Select the “HTML” file type.

then show the wizard.

1. Open a HTML file, select tables.

2. Show existing FoxPro tables, choose “Import Type”.

3. Set FoxPro tables.

4. Show summary, set “Convert Rows”.

5. Import data from each table in a HTML file to a separate FoxPro table.

View imported data in FoxPro table


More about HTML file to FoxPro converter

HTML → FoxPro reference

Type mapping

Value kindin HTMLin FoxPro
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 cellGeneral
Boolean<td>true</td>Logical
JSON<td>{&quot;a&quot;:1}</td> (quotes escaped)(none)

Dialect differences

HTML is a file format and FoxPro 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 FoxPro
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 attributesGeneral (G)
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 FoxPro.
  • HTML values of kind JSON have nowhere to go in FoxPro.

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.