Toad World® Forums

Cannot import Excel file with values based on a formula

#1

When I try to import an Excel file in Toad Data Point, it will not take fields where the value is a formula.

Is it possible to change this value during the import or somehow overwrite it? Because this value isn’t important it can be changed to any another value that Toad Data Point can accept.

#2

Sure. You can remove the column in the import wizard.

#3

I do need the column. I just need a specific value to be changed during the import because it is based on a formula which cannot be imported. See example below where #NAME cannot be imported because it is a formula as you can see.
image

#4

Perhaps you can delete that column and add a column with a static value or perhaps some other Excel cell value.

#5

I suggest fixing the data at the source. In Excel, highlight the cells that have the formulas, copy, then right-click the same area, and paste as values. The cells will now have the result values and the formulas are gone. Then try the import again.