if you have installed a 64-bit ODBC Drive, you will need to use the 64-bit version of Excel. Make sure that you use matching Excel and ODBC Driver, e.g. With ODBC Driver, you can import the data directly into an Excel Spreadsheet and present it as a table.
You can use Microsoft Excel to access data from a MySQL database using ODBC connector. Connecting to MySQL from Microsoft Excel using ODBC Driver for MySQL
