The data import tools that come with dbForge Studio are designed to simplify the process of importing data into databases. These tools offer a user-friendly interface for mapping source data to target database tables, enabling users to import data from various file formats or external sources. The Data Import utilities ensure the accuracy and integrity of imported data, making them a valuable resource for database administrators and developers handling data migration and integration tasks.
Data Import | SQL Server | MySQL and MariaDB | Oracle | PostgreSQL |
---|---|---|---|---|
CSV | ![]() |
![]() |
![]() |
![]() |
XML | ![]() |
![]() |
![]() |
![]() |
TXT | ![]() |
![]() |
![]() |
![]() |
XLS | ![]() |
![]() |
![]() |
![]() |
XLSX | ![]() |
![]() |
![]() |
![]() |
DBF | ![]() |
![]() |
![]() |
![]() |
JSON | ![]() |
![]() |
![]() |
![]() |
Google Sheets | ![]() |
![]() |
![]() |
![]() |
MDB (Microsoft Access) | ![]() |
![]() |
![]() |
![]() |
ODBC | ![]() |
![]() |
![]() |
![]() |
SQL | ![]() |
![]() |
![]() |
![]() |
Data import from the command line | ![]() |
![]() |
![]() |
![]() |
Data import templates | ![]() |
![]() |
![]() |
![]() |