Return
-
Title
Import Wizard hangs using large XLSX files. -
Description
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.
-
Resolution
WORKAROUND:
Save the file as text file via Excel and then import the file using Import Wizard.
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle. -
Defect ID
ST 56577 -
Additional Information
This issue has been fixed in beta version 11, which can be downloaded at http://toadfororacle.com/beta.jspa.