User attempting to import a large XLSX 2007 Excel file containing 2 million plus records into an Oracle table by using the Import Wizard. The wizard hangs at the point where it tries to load the worksheet in order to allow user map worksheet columns to table field names. This window of wizard never opens and Toad ultimately hangs.
Save the file as text file via Excel and then import the file using Import Wizard.
Waiting for fix to be released in a future version of Toad for Oracle.
This issue has been fixed in beta version 11, which can be downloaded at http://toadfororacle.com/beta.jspa.