I am trying to read an excel file.
In some of the columns, the variable type cannot be predicted. It is sometimes text and sometimes a number.
Since I have to define the type in BindVariable(), I sometimes get garbage in the bound variable.
Does anyone know how to solve this?
Is there in Aurora a "TYPE" like EBASIC's ANYTYPE, that might perhaps be usefull for this situation?
Any suggestions would be appreciated.
Use a string variable. The ODBC driver should convert any numerics to a string automatically. If not then the driver is non-conforming.
I tried it as a string and things did not change.
Where can i get an up to date driver?