Excel import does not refresh columns on multi-sheet imports.
Steps to reproduce the issue:
1) Run the script below:
CREATE TABLE TABLE_1
(
C11 NUMBER,
C21 NUMBER,
C31 NUMBER
)
/
CREATE TABLE TABLE_2
(
C12 NUMBER,
C22 NUMBER,
C23 NUMBER,
C24 NUMBER,
C25 NUMBER
)
/
2)Go to Database | Import | Import Table Data and import sheet 1 from the attached file to TABLE_1. To do that please follow the steps below:
Select table TABLE_1
Show data
Next
TABLE_1.xls
Next
Next
Next
Next
Choose commit mode " One commit after all records"
Execute
3 rows successfully imported
3) Now import sheet 2 to TABLE_2 :
Select Object Name "TABLE_2"
Show data
Next
Import from : Select "Excel Type "
TABLE_1.xls again
Next
Next
Select sheet 2 as sheet to import
You can only see 3 columns instead of the 5 that the sheet has (3 is the amount of columns in the first sheet).Toad should show all the columns.
WORKAROUND
This works on version10.1.1.8. Please install this version on another folder if you need to use this functionality
STATUS
Waiting for fix in a future release of Toad for Oracle
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center