Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

how to import data from TOAD to Excel using SQL?

Started by libran, Jan 21 2008 12:57 AM

This topic has been archived. This means that you cannot reply to this topic.

4 replies to this topic

#1
libran

Posted 21 January 2008 - 12:57 AM

Newbie

Members
4 posts

hi,

I need to import data from TOAD to Excel using some SQL code. I need help on how to write this code...anyone please help me and prodive example if possible....

pls..pls..thanx a lot...

#2
Guest_Jordan_*

Posted 21 January 2008 - 04:43 AM

Guests

We can't help you write your SQL unless you tell use your entire schema and what you want out of your SQL. You can save your results as a comma delimited file (CSV) which will give you your excel spreadsheet.

#3
libran

Posted 21 January 2008 - 05:23 PM

Newbie

Members
4 posts

hm...i'm sorry, i'm a total IT idiot. don't really how to explain to you. but the attached file have the window of my TOAD. i hv to import the data below to an Excel file, which alr contained VBA code for other function.

I hope you are clear enough...pls check the attached file..

Attached Files

TOAD.doc 77.5K 1046 downloads

#4
Guest_Jordan_*

Posted 22 January 2008 - 05:12 AM

Guests

Inside your results window where you see "106-40304.1" right click and select "Save As". Select the number one option "ASCII, Comma Delimited" and follow the instructions. This will create an excel file.