Export and import data

Last modified: May 28, 2025

This section provides comprehensive instructions for exporting and importing data using built-in tools and command-line options. It includes supported formats such as CSV, JSON, XML, DBF, XLS, and MDB, along with features like applying WHERE conditions, migrating data from other servers, and importing to new tables. Topics also cover the use of templates, additional command-line arguments, and exit codes for automation and troubleshooting. The content is designed to support efficient and consistent data transfer across various scenarios.

In this section

Data export overview

Export data

Save and use export templates

Export data from the command line

Additional /dataexport arguments

Exit codes used in the command line for /dataexport

Data import overview

MDB import

CSV import

DBF import

XLS import

Text Import

JSON import

XML import

Export data based on a WHERE condition

Migrate data from other servers

Import data to a new table

Save and use import templates

Import data from the command line

Additional /dataimport arguments

Exit codes used in the command line for /dataimport