How to import data from an Excel file into a table?

See 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

253891 7 /
Follow / 13 Dec 2013 at 7:40pm

this was not helpful.

Follow / 13 Dec 2013 at 8:11pm

@mdahlst

could you open issue and tell what problems you have?

Brg

Damir

Follow / 22 Jan 2014 at 6:54am

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!

Follow / 15 Jul 2014 at 3:38pm

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?

Please help

Follow / 17 Dec 2014 at 4:20pm

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.