Mixed Types

[Jim Barry]

When using the IWorksheet.ImportDataTable call, varchar columns that contain numeric-only values are having leading zeros truncated.

Is there a way to get XLSIO to support the registry key of HKey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/ImportMixedTypes?

[Jim Barry]

OK, Solved my own problem...

I had to set the bPreserveTypes flag to true in my call to ImportDataTable

[Administrator]

Hi Jim,

Thanks for the update.

Regards,
Bhuvana