Toad 11 Import From Excel

Asked By fabion cole 20 points N/A Posted on - 02/24/2013

Hi. I am currently working on a project and I'm using Toad 11 and as I am new to this, I am not quite sure on how to use some of its capabilities.

But anyway, I have an excel file here which I can use in my project. I just don't know how to do it:

Toad 11 Import from Excel.

So if you can please comment some easy ways to do it, thanks!

• Status: Open
• Question Views: 1189
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Software Others

Best Answer by Guy V Mohr

Go To Solution

Answered By Babb Samantha 10 points N/A #165758

Toad 11 Import From Excel

Hello Cole,

How to import data from Excel file to table using toad

 

There are two ways you can do that: 

 

1. Create a .CSV file and using SQL LOADER WIZARD load the .CSV file. SQL loader wizard is under the DBA tab of TOAD.
2. Import the Excel data directly using import option. Import option is available under Database tab of TOAD. 

 

With these both way you can transfer Excel file to TOAD.

 

Hope this would help you.

 

Thank you.

About Babb Samantha

Questions
4

Answers
202

Best Answers
45

• Vote Up 0 Vote Down

• Posted on - 02/27/2013
• Question Category: Software Others

Best Answer

Best Answer

Answered By Guy V Mohr 0 points N/A #165759

Toad 11 Import From Excel

This is I think the liked process that's used by more users to Toad. By selecting data in the grid, select & copy all, ALT+TAB, now paste – voilaYour data are now in Excel. Problem with this work?

No!

If yes!

Make sure Excel is on. You won't get any formatting. If you choose-notch gourmet homee data may possiblyEhit upon afteboundlesse-thumbs downct, there's thumbs down was with the intention of with noigned fore with the intention ofhanismhat caseith notentednted crein that casegcontentedcro.

About Guy V Mohr

Questions
6

Answers
118

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 03/09/2013
• Question Category: Software Others