Home » SQL & PL/SQL » Client Tools » transfer Data in tables into Excel sheet
transfer Data in tables into Excel sheet [message #249378] Wed, 04 July 2007 04:02 Go to next message
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.
Re: transfer Data in tables into Excel sheet [message #249404 is a reply to message #249378] Wed, 04 July 2007 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: transfer Data in tables into Excel sheet [message #251104 is a reply to message #249378] Thu, 12 July 2007 07:11 Go to previous messageGo to next message
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!
Re: transfer Data in tables into Excel sheet [message #256039 is a reply to message #249378] Thu, 02 August 2007 16:45 Go to previous messageGo to next message
charansundaram
Messages: 8
Registered: August 2007
Location: INDIA
Junior Member

hi,

1. Use save as option.

2. Select format as Tab delimited.

3. Save to c:\DATA.TXT

4. Open DATA.TXT in notepad.

5. Copy and Past in EXCEL.
Re: transfer Data in tables into Excel sheet [message #260567 is a reply to message #249378] Mon, 20 August 2007 05:37 Go to previous messageGo to next message
panan
Messages: 2
Registered: June 2007
Junior Member
Hi,
Maybe you can try OraLoader.

Regards
Panan
Re: transfer Data in tables into Excel sheet [message #262521 is a reply to message #249378] Mon, 27 August 2007 06:21 Go to previous message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
May be your excel file is open. Close the excel file and try again
Previous Topic: TOAD and remote java debugging
Next Topic: Newbie for Oracle 9i
Goto Forum:
  


Current Time: Mon Dec 05 15:21:20 CST 2016

Total time taken to generate the page: 0.09419 seconds