Online Documentation for SQL Manager for MySQL

Import Data Wizard

Import Data Wizard allows you to import data to a table / view from any of supported formats (MS Excel, MS Access, DBF, XML, TXT, CSV, HTML, MS Excel 2007, MS Word 2007, ODF). You can save your settings as a template any time for future use.

To start the wizard, right-click the table/view in DB Explorer, select the Data Manipulation | Import Data... context menu item.

Alternatively, you can open the Data tab of Table Editor / View Editor, right-click the grid there, then select the Data Manipulation | Import Data to <object_name>... context menu item.

• Setting source file name and format
• Selecting the source to import data from
• Setting correspondence between the source and target fields
• Adjusting common data formats
• Setting advanced field formats
• Setting import mode and data write type
• Customizing common import options
• Importing data