Toad 11 Import From Excel

Asked By 20 points N/A Posted on -
qa-featured

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!

SHARE
Best Answer by Guy V Mohr
Answered By 0 points N/A #165758

Toad 11 Import From Excel

qa-featured

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.
Best Answer
Best Answer
Answered By 0 points N/A #165759

Toad 11 Import From Excel

qa-featured

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.

Login/Register to Answer

Related Questions