Why Import Wizard does not import Excel fields based on a formula?

Why Import Wizard does not import Excel fields based on a formula?

Follow / 6 Dec 2010 at 11:49pm
Pic2.gif

I am using the import wizard to import worksheet data into an Oracle table.  The worksheet columns are a mix of literal and formula dervied values. 

When the import process is executed, the fields containing the literals values are imported into the Oracle table correctly but the forumula derived cell values are brought over as a NaN.

I did notice that when I was in the Import Wizard's File Preview form, the formula based cells are showing values of NaN.  However, when I click the Excel view icon (upper right Excel icon), it displays the correct data that the forumula is deriving.  The screenshot shows what I'm referring to.

Anyone have any ideas on what the issue is or any work arounds?

Thanks.

Pic2.gif

Replies