Imporint Excel Data into SQL with VB6

[pradeepss]

I have a problem importing the excel data in to SQL with VB6.
The problem is the cells which i am trying to import has a formula in it. And when i try to import it gives me 0 values. not sure how to import cells with formula as a value of the formula.

please help

[pradeepss]

Its almost been 6 days and nobody replied to this post. please help me out here???