Posted by: Daniele
Hi,
I need to get data from an excel sheet; I can't use ActiveX integration
because on the servere running application MS-Office is not installed, so
I'm trying to use ODBC connection.
The problem is that some values in an Excel column may be returned as Null
when the underlying value is not a Null. This typically occurs when numeric
and text datatypes are intermixed within the same Excel column.
To avoid this I need to add the option IMEX=1; to the Excel connect string
in the OpenDatabase method.
Is there anyone who knows how could I set it ?
Thanks
Daniele