Subscribe to our news:
Ingo Bindbeutel: "I did buy Firebird Maestro before, because it is an excellent application and does a very very good work for me! I tried AnySQL and I did buy it, because it's a wonderful application too! Both are similar to use and easy to work with it! I am impressed by the quality and stability of the product! To all members of the SQL Maestro - Team: "keep going this way and make many people happy in using your software!" Thank you for making my life easier and my work productive".
Steve Naidamast: "I just downloaded your new offering of AnySQL Maestro. What a nice product. I was immediately able to connect to an Access database to review the data.
I have already purchased from you your Oracle Maestro as well as your SQLite Maestro.
I am curious as to why you have decided to release such a nice product as Freeware...
Keep up the excellent work".
Add your opinion
AnySQL Maestro 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 database 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
Dec 12, 2016
New version features updated data import and data export tools, nullable column checker, colored tabs, enhanced data grids, performance and usability improvements, and some other useful things.
Feb 11, 2013
New version introduces enhanced data management abilities, advanced SQL Dump wizard, updated SQL Editor and other new features.
Feb 11, 2013
Features up-to-date list of ODBC drivers / OLE DB providers and appropriate connection strings AnySQL Maestro has been examined with.
The article contains a list of ODBC drivers and OLE DB providers the software has been examined with. The corresponding connection strings are also included.
Feature of the day
AnySQL Maestro allows you to import data from Excel, CSV, text files and more.
AnySQL Maestro provides you with a powerful tool to represent numeric data as diagrams.