Toad World® Forums

failed to upload Excel file to existing table


#1

Below is error msg when uploading Excel file to existing Oracle table.

After 3 tries including reformatting the Excel file (rounding numbers, for
example) I used commercial 2.7 and successfully imported the original file.

8:20:21 AM Thread (27) Import Started [3/22/2011 8:20:21 AM]
8:20:21 AM Thread (27) Processing “PNL_HERITAGE_ORA.xls” into “MJBEATR.XPR_PNL”
8:20:21 AM Thread (27) Importing 1 out of 1 files
8:20:21 AM Thread (27) Reading from file PNL_HERITAGE_ORA.xls
8:20:21 AM Thread (27) Object reference not set to an instance of an object.
8:20:24 AM Thread (27) Error importing data, please check file format options:
Object reference not set to an instance of an object.
8:20:24 AM Thread (27) Import Finished [3/22/2011 8:20:24 AM]
8:20:24 AM Thread (27) Import time: 00:00:03.0308038


#2

Hi Mike,

Would it be possible to send me a sanitized version of the .xls file?

Alan


#3

[ Attachment(s) from michael.beatrice@usbank.com included below]

Nice to hear from you Alan — thought you kept to DB2 !

Here’s the file with some minor text changes. Original had 2 other sheets but
only tried to import this one.

From:
Alan Bala To:
"ToadforDataAnalysts@yahoogroups.com"
Date:
03/22/2011 12:27 PM Subject:
RE: [ToadforDataAnalysts] failed to upload Excel file to existing table Sent by:
ToadforDataAnalysts@yahoogroups.com


#4

I just ran into this error also. We fixed and it will be in the next Beta. In
the meantime you would need to use new table.

Debbie