Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Toad crashes with import table data wizard from excel.
설명
Import table data wizard crashes with error message "List index out of bounds(1)" appearing just before content of the selected excel file is going to be shown in the Toad import data wizard (Preview File and Define Fields).
원인
This happens every time when importing data from the second excel file 2 sheet 2 containing different columns than the first excel file 1 sheet 2 into the same table used in previous import from the first excel file 1 sheet 1.
Steps to Replicate:
Select excel file 1 and sheet 2 active.
Select excel file 2 and sheet 2 active.
해결 방안
WORKAROUND
Select first excel file 1 and set sheet 1 active.
Select second excel file 2 and sheet 2 and import without Toad crashing.
STATUS
Waiting for fix in a future release of Toad for Oracle.