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:
http://www.enduserguides.com/software/office/mso/eug_mysqlodbc.html

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?
Thanks,
Gregg

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't export data into excel
2805
April 06, 2012 01:07AM
1524
July 03, 2012 05:13PM
1071
December 04, 2012 07:45AM
1087
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.