Import data from files to 1 database table without programming

by

Posted on by

Want to batch import data from files to 1 database table?

Using FileToDB, a native GUI tool, you can batch import data from files to 1 database table easily and fast, no need to program, just a few mouse clicks!

Support multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF, etc.

Import file data to database table - multiple types of files

Support multiple types of RDBMS, such as Access, DB2, DBF, MySQL, Oracle, PostgreSQL, SQL Server, SQLite, Amazon Redshift, Azure SQL, etc.

Import file data to database table - multiple types of RDBMS

Here you can download and install FileToDB.

Batch import data from files to 1 database table

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

Batch import files data to 1 table - task window

Select a file type.

Batch import files data To databases - select file type

then show the import wizard.

1. Select a folder.

Batch import files data to 1 table - select a folder

2. Config file parameters.

Batch import files data to 1 table - config file parameters

3. Select a table and config fields.

Batch import data from file to 1 table - select table

4. Preview data.

Batch import files data to 1 table - preview

5. Import to table or save sql script to file.

Batch import data from files to 1 table - import data

More about FileToDB – the tool to batch import data from files to 1 database table

30-day free trial Download FileToDBUS$59.95 Buy FileToDB

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.