Import/Export database data from/to files without programming

by

Posted on by

Want to load/unload database data from/to files?

Using DBLoader, you can load/unload database data from/to files easily and fast, just a few mouse clicks!

You can import data from multiple types of file, such as TXT, CSV, TSV, Excel, JSON, XML, RDF, etc.

You can export data to multiple types of file, such as SQL, TXT, CSV, TSV, Excel, JSON, XML, HTML, etc.

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

load/unload database data - multiple types of RDBMS

Support Windows, Linux, macOS

Here you can download and install DBLoader.

Import/Export database data from/to files

Import, you can import

  • Load From File
  • Load From Files (Folder)

For example, import TXT files to table

Click “Load From Files (Folder)” at task dialog.

load/unload database data - task window

then show the wizard.

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

Export, you can

  • Unload From Table
  • Unload From Query
  • Unload All Tables
  • Unload Similar Tables

For example, export Collections to Excel files

Click “Export All Collections” at task dialog.

load/unload database data - task window

then show the wizard.

1. Select file type.

Export data from database Tables To Files - select file type

2. Select Tables.

Export data from database Tables To Files - select tables

3. Enter data folder.

Export data from database Tables To Files - enter data folder

4. Map.

Export data from database Tables To Files - map

5. Summary.

Export data from database Tables To Files - summary

6. Export.

Export data from database Tables To Files - export

You can schedule and automate this converting task by:

1) Save session and create .bat file.

2) Set scheduled task.

More about DBLoader – the tool to load/unload database data to files

30-day free trial Download DBLoaderUS$95.0 Buy DBLoader