Note: If you are working with Oracle 8.0 or earlier on a Windows 2000 or later OS, uncheck "Watch Progress"
Note: once you have a ctl file you can:
***Update*** the above answer is obselete, instead please go to the Toadworld blog post "Create and Load Oracle Tables from Excel Spreadsheet using Toad" at http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/03/29/create-and-load-oracle-tables-from-excel-spreadsheet-using-toad
this was not helpful.
could you open issue and tell what problems you have?
Nice article, thanks. Having never tried the Import wizard, I have to say I'm quite impressed. For one who spent far too much time hacking together scripts to massage/import data files, let alone XLS to CVS, etc... This is very refreshing to "just have it work". Thanks for the pointer. Go Method1!
I have a simple excel spreadsheet - one column of data. I want to use the import function but I am having issues. I am doing the following steps:
1. In Object Palette - Right click on the table name (the table is empty)
2. Action Console
3. Import Data
My problem - I do not have the option to select the file that has my data to import. I see Section Destination Schema Object Type:Table Object Name: My Table
Where is the browser to select the data?
This process does not work. Like most of the TOAD processes I follow on here. I get to point where an error occurs and then I can't find a fix for the error. Or I find a mention of the error, but the fix is so trivial that I just end up chalking it up to TOAD and using another program.