-
Sean Cheshire
mysql excel connection ms-query
I need to import some data to Excel from MySQL DB via MS Query (using MySQL ODBC driver). At the first step I set up Data Source name, TCP/IP server, port, username, password and schema name. When I pressed the Test button, the connection worked fine. Next, I selected the table name, needed columns, filters, sort order and get to the Query Wizard – Finish screen. Regardless of choosing Return data to Excel or View data in MS Query, after pressing the Finish button, I get an MS Query crash.I’m gi