I have had this same exact problem. It has forced me to use cancel when it prompts for the table and input the SQL manually. Basically I connect to the datasource and hit cancel to the next screen to allow me to enter the SQL.
I would love to know why this happens as well. David Norman Wells Fargo Services -----Original Message----- From: Huang, Ou [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 1:33 PM To: mysql@lists.mysql.com Subject: Error when importing mysql table into excel via ODBC Hello, I have a mysql ODBC driver 3.51.11.00 installed on a xp machine in order to connect to mysql server (on unix) remotely via the ODBC driver. The ODBC driver was working well. What I am trying to do is to import one of the mysql table into excel through New Database Query option in Excel. However, I was not able to import the table , an error was generated at the end of Query Wizard set up: Unknown table "histsum_0" in field list The table is actually called "histsum" but I don't know why it is saying histsum_0. Has anyone ran into this error before? I have four tables in the same database, only this one couldn't be imported, the other three are working fine. I have searched over the internet but didn't find much info on this error. Any help would be appreciated! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
