Toad World® Forums

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


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?




There seems to be an error exporting Excel text values from formulas. I have entered CR80501 and it will be fixed in the next Beta (approx Dec 16th)