When you use MySQL to query a database, you have the ability to ... with any MySQL query to create tab-delimited files that Excel can open. After loading the data into Excel, you are free to ...

Use the Excel file as an ODBC data source (connection string info here), and your MySQL database as the destination ... oBook Set oBook = oExcel.Workbooks.Open(Wscript.Arguments.Item(0)) oBook ...