Hi,
I'm using DTS to import data in named ranges from Excel to SQL. Most of the
named ranges contain formulas. It is the result of those formulas that I
need to get into SQL. It is not working, it just comes in blank in SQL.
There are some named ranges in Excel that do contain actual text and numbers
(not formulas) and those come in great to SQL.

Is there something I missed? How can I get the result of the formula (the
cell value) into SQL??

Thanks for the help,

Dan