TOAD Data Extract Excel 2007 [message #481573] |
Thu, 04 November 2010 06:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
alboracle
Messages: 4 Registered: November 2010 Location: Tirane, Albania
|
Junior Member |
|
|
I have a question regarding data extraction to Excel.
Is there any patch or update that makes it possible to extract to
Excel 2007 and not only 2003?
thanks
|
|
|
|
|
|
|
Re: TOAD Data Extract Excel 2007 [message #481600 is a reply to message #481591] |
Thu, 04 November 2010 08:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
alboracle
Messages: 4 Registered: November 2010 Location: Tirane, Albania
|
Junior Member |
|
|
Hi,
Actually I have Office 2007 installed.
The problem is that the files created after extraction are of excel 2003 type, which sometimes is a problem when I have to work with too much data.
I just thought there maybe a solution to this, a patch or sth like that.
|
|
|
Re: TOAD Data Extract Excel 2007 [message #481642 is a reply to message #481600] |
Thu, 04 November 2010 16:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
How many is "too much" (in number of records)? I *think* that Excel limited number of rows to 64K. Is that barrier removed in Excel 2007? (I did some googling; it seems that limit is now 1M).
If export to Excel doesn't work properly, would it be possible to save data as a CSV, which can later easily be opened in Excel?
|
|
|