I’m trying to import excel data to database with ExportDataTable function. One of the sheet’s columns contains only integers (kind of IDs), but after calling the function above, in the filled dataset appears that this column’s type is set as float instead of int.
I also set CheckMixedValueType = true in ExportTableOption.
Do I something wrong, or is the default numeric type float when exporting into dataset?
Please let me know if I misunderstand something.