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.
Support multiple types of RDBMS, such as Access, DB2, DBF, MySQL, Oracle, PostgreSQL, SQL Server, SQLite, Amazon Redshift, Azure SQL, etc.
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.
Select a file type.
then show the import wizard.
1. Select a folder.
2. Config file parameters.
3. Select a table and config fields.
4. Preview data.
5. Import to table or save sql script to file.
More about FileToDB – the tool to batch import data from files to 1 database table