MySQL Forums
Forum List  »  MySQL for Excel

Can't export data into excel
Posted by: Gregg Gourde
Date: April 06, 2012 01:07AM

I am trying to make a pivot table with excel and used this webpage for help:

While setting up data sources (ODBC) I tested the connection and it said 'connection successful.'
Then in excel I followed the instructions from the above website, and again in the data link connection panel I tested the connection and it worked.

Then the problem occurred when I tried to import the data. I got the following message:

Initialization of the data source failed.

Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database.

Any ideas?

Options: ReplyQuote

Written By
Can't export data into excel
April 06, 2012 01:07AM
July 03, 2012 05:13PM
December 04, 2012 07:45AM
December 07, 2012 03:44PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.