How to Import and Export Data

Importing data is the process of retrieving data from sources external to Active Table Editor (for example, an Excel file) and inserting it into database tables. Exporting data is the opposite process of extracting data from database tables into some user-specified format.

Active Table Editor can export data into CSV, HTML and Excel files and Import it back from Excel files.

Import and export are designed to save user time or can be used to import a starting set of data

In this tutorial, we will be Exporting and Importing data. We will also review common import problems.
This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Active Table Editor.

All our ETL tools have no limitations, which means you can load your data today and solve all the data quality problems right now.

Our WIKI has more detailed information if you are stuck post your question on our support forum and we will do our best to assist you