In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0.
Importing MySQL data into Excel is a common and important operation in MySQL for Excel. There may be times when you need to analyze the data stored in several MySQL tables or views, (possibly in an ExcelPivotTable which will be the subject of a future blog post), and to do it you need to dump the data into Excel as the first step. Starting with MySQL for Excel 1.3.0 we introduced a feature that allows you to import the data from multiple MySQL tables or views in a single operation.
Remember you can install the latest GA or maintenance version using the MySQL Installer or[Read more...]