OraFAQ Forum: Client Tools » transfer Data in tables into Excel sheet

Home » Other » Client Tools » transfer Data in tables into Excel sheet

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

transfer Data in tables into Excel sheet [message #249378]

Wed, 04 July 2007 04:02

lavlina
Messages: 3
Registered: July 2007

Junior Member

Hi,

I wish to transfer my Data in tables into Excel sheet. I tried "save as" in table view but it is giving me
1. Access violation at address 13800000. Read of address 13800000
and
2. Access violation at address 004D5254 in module 'TOAD.exe'. Read of address 00000070

error. Can neone suggest me why this error in first place and an alternate way to transfer data directly in Excel Sheet with proper column Heading. I tried exporting data but that is not helping.

Report message to a moderator

Re: transfer Data in tables into Excel sheet [message #249404 is a reply to message #249378]

Wed, 04 July 2007 06:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

For exception, post your question to Microsoft or Quest.

Quote:

I tried exporting data but that is not helping.

Why? What is the problem?

Regards
Michel

Report message to a moderator

Re: transfer Data in tables into Excel sheet [message #251104 is a reply to message #249378]

Thu, 12 July 2007 07:11

sstellini
Messages: 32
Registered: April 2005
Location: Malta

Member

I don't know why do you get that error with Toad, perhaps youv'e got too many rows..?
but anyway, there is another way to open the data in Excel = you can run the report using SQLPlus and save it in HTML format, which is then easy to open in Excel.

Just don't forget to SET MARKUP HTML ON!

Report message to a moderator