Oracle data load from Excel

[prohan]

Hello gurus:

I am trying to load data from an Excel spreadsheet into an Oracle table, using PL/SQL Developer's ODBC Importer. However, I have run into a rather intractable problem:
One of the fields in the spreadsheet is a zip code, but when I load the spreadsheet, this zip code is not imported into many (but not all) of the records in the table.
I thought perhaps that the format of these zip codes might have something to do with the problem, so I tried first changing all zip codes to the Special - Zip code format. That did not solve the problem.
Then I tried formatting it as text, left aligned, but that did not work either.
Does anybody have any idea why this would be happening?
My version of PL/SQL Developer is 7.1.1.1339
Thanks.

 

[Marco Kalter]

Can you update to 7.1.4 and try again? Several fixes were applied to the importers. If it still fails, can you send me the Excel file?

 

[prohan]

Marco:

I just did the update and ran the import again. The results were the same. Unfortunately, the spreadsheet is considered confidential, so I can't send it to you. Can you tell me what to look for instead?

 

[prohan]

I just had an idea: I can delete all confidential data from the spreadsheet and send you just the zip codes that are causing the problem. But how do I send it to you?

 

[Marco Kalter]

You can send it by e-mail to support@allroundautomations.com with a reference to this forum topic.

 

[prohan]

Thanks Marco. I have just sent it.

 

[prohan]

Marco, are you looking in to this for me?
Thanks.

 

[Marco Kalter]

Yes, I will keep you posted.