I am trying to import data from an Excel file into an Oracle table. After matching the table columns with the spreadsheet (first column I specified null since I have a table trigger to load sequence number when null, second column matches to column A in the Excel file), Toad loads all of the data except for the first Excel column. Tried the same load using Toad 9.7.2.5 and it works fine.
WORKAROUND:
Add an empty column to the Excel file, just before the first data column (making column B the first data column instead of column A) and the import will work fine.
STATUS:
This issue will be addressed in the next release of Toad for Oracle.
