Reading an excel file

[Haim]

Hello,
I read an excel file with the CDatabase class.
everything works fine, but I have these issue:

1. One of the columns may contain either a string or a number formatted as a number. Is ther a way to define the type in the bindvariable or getdata member functions to    something similar to VARIANT so that I always get a correct value?

2. I read the excel file in a loop, testing for get() returning null.
some excel files esult in many more lines read than actually are  there. (the last line being repeated...)
How can I overcome this?

Any helpp would be appreciated.

Haim