Re: Can't export data into excel
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.
Subject
Views
Written By
Posted
3170
April 06, 2012 01:07AM
Re: Can't export data into excel
1684
July 03, 2012 05:13PM
1620
July 23, 2012 02:44PM
1310
October 24, 2012 04:49PM
1252
December 04, 2012 07:45AM
1266
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.