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.