Home » SQL & PL/SQL » Client Tools » TOAD Data Extract Excel 2007 (Toad )
TOAD Data Extract Excel 2007 [message #481573] Thu, 04 November 2010 06:08 Go to next message
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 #481575 is a reply to message #481573] Thu, 04 November 2010 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68045
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you post this question to Quest? or in a TOAD forum?

Regards
Michel
Re: TOAD Data Extract Excel 2007 [message #481576 is a reply to message #481575] Thu, 04 November 2010 06:37 Go to previous messageGo to next message
alboracle
Messages: 4
Registered: November 2010
Location: Tirane, Albania
Junior Member
Thank you for the suggestion.
I still think the question is relevant in this forum too.

Regards
Re: TOAD Data Extract Excel 2007 [message #481581 is a reply to message #481576] Thu, 04 November 2010 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68045
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes it is, it was just an advice, you will likely have more answers and more appropriate answers in other forums.

Regards
Michel
Re: TOAD Data Extract Excel 2007 [message #481591 is a reply to message #481581] Thu, 04 November 2010 08:30 Go to previous messageGo to next message
Littlefoot
Messages: 21691
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which TOAD version do you use?

When you write a query (in Editor), run it and it retrieves some records, then you can right-click within the Data Grid and choose an option named "Save As" or "Export Dataset" (or similar). What does it offer? Is there "Excel file" and "Excel instance"? What happens when you select one of those? I guess that it should do the job and open Excel you've got (whether it is version 2003 or 2007).

If it doesn't work as I suppose, could you describe what you did and how? What was the final result?
Re: TOAD Data Extract Excel 2007 [message #481600 is a reply to message #481591] Thu, 04 November 2010 08:44 Go to previous messageGo to next message
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
Littlefoot
Messages: 21691
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?
Previous Topic: Previously executed block
Next Topic: Question w.r.t SQL*PLUS
Goto Forum:
  


Current Time: Sat Dec 04 20:29:33 CST 2021