Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page how to import data from TOAD to Excel using SQL?
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-21-2008, 02:57 AM
libran libran is offline
Newbie
  
Join Date: Jan 2008
Posts: 4
Rep Power: 0
libran is on a distinguished road
Default how to import data from TOAD to Excel using SQL?
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...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 01-21-2008, 06:43 AM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Age: 25
Posts: 4,514
Last Blog:
Zend: PHP Security Web...
Rep Power: 50
Jordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud of
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default
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.
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 01-21-2008, 07:23 PM
libran libran is offline
Newbie
  
Join Date: Jan 2008
Posts: 4
Rep Power: 0
libran is on a distinguished road
Default
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 To view attachments your post count must be 1 or greater. Your post count is 0 momentarily.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 01-22-2008, 07:12 AM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Age: 25
Posts: 4,514
Last Blog:
Zend: PHP Security Web...
Rep Power: 50
Jordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud of
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default
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.
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-13-2008, 09:52 AM
phpforfun's Avatar   
phpforfun phpforfun is offline
Programming God
  
Join Date: Feb 2008
Posts: 513
Last Blog:
ubuntu... do not upgra...
Rep Power: 5
phpforfun will become famous soon enough
Default
But he wants to do that using SQL..
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import SQL file command line Ronin Database & Database Programming 14 01-25-2008 02:56 PM
Data types of PL/SQL and SQL Patrick Database & Database Programming 0 10-07-2007 02:52 AM
Java:Tutorial - Data Types John Java Tutorials 6 07-02-2007 09:16 PM
Best program for SQL database manipulation Rhadamanthys Database & Database Programming 3 07-02-2007 02:32 PM
Inserting Data into an Excel Spreadsheet Lop C# Programming 3 06-27-2006 01:23 PM


All times are GMT -5. The time now is 11:15 PM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

John ........ 87.50000
dargueta ........ 75.00000
Xav ........ 50.00000
MeTh0Dz ........ 20.00000
gaylo565 ........ 18.00000
Johnnyboy ........ 3.00000

Contest Rules

Sponsors

Linux Forums
Electronic Music

Ads