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