Excel ODBC Connection issue

Posted by: tahir

Excel ODBC Connection issue - 19/07/2009 10:27

I'm trying to connect to a MySQL DB via Excel 2000, have d/loaded and installed the mySQL ODBC driver and set it up as a data source in "Data Sources (ODBC)", I've successfully tested the connection, but when I try to access it in Excel it says it can't find any tables. I'm running Vista if that makes any difference.
Posted by: tahir

Re: Excel ODBC Connection issue - 19/07/2009 10:40

I misspelled my google terms, I've discovered this is a known bug in our version of mySQL, using an older version of the connector works.