Quick Start
Connect to MySQL
HTTP Tunnel
SSH Tunnel
Databases
Schema
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Foreign Keys Data Selection
Uniques and Checks
Rules and Triggers
Privileges
Import/Export
Function
View
Tablespace
Cast
Language
Aggregate
Conversion
Domain
Trigger Function
Operator
Operator Class
Sequence
Type
Queries
Visual Query Builder
Data
Manage Users
Backup
Data Transfer
Schedule
Server Monitor
Data Synchronization
Structure Synchronization
Console
Virtual Grouping
Maintaining your databases/tables
Preferences
General
Tabs
Tables
Queries
  Working with Import / Export Wizard
 

Import data using import wizard

  1. In the Database Window , click the Table tab.
  2. If you have an existing table to which you want to import data, select the table. Otherwise, do not select any table.
  3. Select Import Wizard from the table menu.
  4. An Import Wizard dialog box will be shown.
  5. Depending on the import data format, you should follow several steps to complete the import process.

    Note:
    Supports different kind of file formats - Excel, Text/CSV, XML, DBase
    Supports importing multi-files and sheets
    Supports different import modes (Append, Update, Append/Update, Delete and Copy)

Export data by using Export Wizard

  1. In the Database Window , click the Table tab.
  2. Select the table which you want to export data. Select Export Wizard from the table menu.
  3. An Export Wizard dialog box will be shown.
  4. Select which data format you want and click OK button to proceed.