Bulk import data from HTML files to SQL Server tables at one time

by

Want to bulk import HTML files into SQL Server tables at one time?

Try Withdata software FileToDB, a HTML to SQL Server converter for SQL Server for Windows, MacOS, and Linux, Easy and Fast.

Download Withdata FileToDB Download FileToDB

Bulk import HTML files into SQL Server tables

Login to SQL Server -> Choose HTML files -> Set SQL Server tables -> Import HTML files to SQL Server tables

Choose SQL Server and logon.

bulk import HTML files into SQL Server tables - Choose SQL Server and logon

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

bulk import HTML files into SQL Server tables - task window

Select the “HTML” file type.

bulk load HTML files into SQL Server tables - select file type

then show the wizard.

1. Select a folder that constains HTML files.

bulk import HTML files into SQL Server tables - select a folder

2. Config first HTML file importing options.

bulk import HTML files into SQL Server tables - config first file

3. Set “Import Type”.

bulk import HTML files into SQL Server tables - set tables

4. Map SQL Server tables to HTML files.

bulk import HTML files into SQL Server tables - map

5. Summary. Set “Convert Rows” and “Skip Rows” if need.

bulk import HTML files into SQL Server tables - preview

6. Import HTML files to SQL Server tables, 1 file to 1 table, one by one.

bulk import HTML files into SQL Server tables - import data

View imported data in SQL Server table

bulk import HTML files into SQL Server tables - view data


More about HTML file to SQL Server converter

See also: