Subscribe to our news:
Partners
Testimonials
Piter Jason: "I wanted to take this opportunity to thank SQL Maestro Group for providing me the tools to succeed. I have no doubt that without them I would have failed to do my job. I am proud that I have suceeded. Thank you".
Samuel Poole: "I recently downloaded and ordered MySQL Data Wizard, and I thought I would drop you a note to let you know that it is the software I needed . Well done, keep up the good work, and please accept my very best regards. Please feel free to use the contents of this e-mail along with my name, as an endorsement of your excellent product".
More
Add your opinion
Customers
|
Data Wizard for MySQL online help
Data Import
Data Import 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. To run the wizard, use the Run Data Import Wizard link at Home page.
The following formats are supported:
• | Microsoft Office Excel 95-2003 |
• | Microsoft Office Excel 2007 |
• | Microsoft Office Access 2007 |
• | Delimiter-separated values (CSV, DSV, TSV); |
• | Text files (Fixed-width columns) |
• | ODBC data source (any data source accessible via ODBC driver or OLE DB provider such as SQL Server, Oracle, MySQL, MS Access, Text files, MS Excel, etc). |
To import data,
See also: Templates
|
Company news
Feb 11, 2016
New version features two new wizards for unloading and loading BLOB data, updated Data Import tools, command-line builders for all the wizards as well as some other new features.
Dec 6, 2013
New version features updated Data Import and SQL Dump tools, data export to JSON format, redesigned Start Page, and some other useful things.
Feb 11, 2013
Features up-to-date list of ODBC drivers / OLE DB providers and appropriate connection strings AnySQL Maestro has been examined with.
Resources
The article puts forward a scenario for implementing row level security in MySQL 5.x.
Feature of the day
Data Wizard for MySQL provides you with Tray Agent to execute scheduled tasks without running Data Wizard.
Data Wizard for MySQL: Data Export allows you to export several tables at a time.
|