MySQL Forums
Forum List  »  MySQL for Excel

Re: Can't export data into excel
Posted by: Evan Coleman
Date: July 03, 2012 05:13PM

I am also having this problem. Any assistance would be appreciated.

EDIT: I have solved the issue for myself.

(1) Make sure you have downloaded the right kind of ODBC for your copy of Microsoft Office. I had x64 for a x32 copy, and this led to problems.

(2) Try this in Excel: Data --> From other sources --> From Data Connection Wizard --> ODBC DSN --> <yoursourcename> --> select table, next --> finish --> Pivot Table

If (2) fails, try putting the Pivot Table in a separate sheet (during the last step)



Edited 1 time(s). Last edit at 07/04/2012 12:41AM by Evan Coleman.

Options: ReplyQuote


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