Subscribe to our news:
Charles Richardson: "In particular, the graphical schema design module is wonderfully smooth and responsive".
Tad Stephens: "I think this is a great product and your quick and helpful reply has shown me the support is there as well. I will purchasing my license today".
Add your opinion
SQL Maestro for MySQL online help
Import Data Wizard
Import Data Wizard provides you with a graphical user interface to import data from the most popular files formats into existing MySQL tables. It allows you to adjust data formats, empty target tables, execute custom SQL scripts, etc.
Import Data tool supports:
|•||Microsoft Office Excel 95-2003|
|•||Microsoft Office Excel 2007|
|•||Microsoft Office Access 2007|
|•||Delimiter-separated values (CSV, DSV, TSV)|
|•||ODBC data sources (any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc.)|
In order to run the wizard you should
|•||open the table in Table Editor; |
|•||select the Import Data item from the Navigation Bar. |
To import data,
See also: Export Data Wizard
SQL Maestro Group wishes you Merry Christmas!
We're happy to grant you a 25% discount for all our products and bundles till December 31!
Dec 20, 2012
New version comes with advanced SQL Dump wizard, new Report Designer tool, enhanced data management abilities, and many other new features.
Mar 28, 2012
New version comes with a powerful Database Backup tool, lots of new features in SQL editors and viewers, improved data grids as well as with many other useful enhancements.
Jun 7, 2011
New version features tools to generate CRUD stored procedures and updatable views, data import from ODBC data sources, updated Data Analysis tool, and other useful things.
The article puts forward a scenario for implementing row level security in MySQL 5.x.
Find out the way MySQL Maestro can help you to realize the new MySQL 5.1 features in practice. Detailed examples are included.
Get to know all the new features of MySQL 5 (ACID Transactions, Stored Procedures and Functions, Triggers, Views, etc.) and the way MySQL Maestro can help you to use them easily and effectively in practice from our new article. Examples are included.
Feature of the day
SQL Maestro for MySQL allows you to make a copy of a database object by dragging it from one database to another.
SQL Maestro for MySQL provides you with an ability to export data to any of 14 available formats.