Free Support Forum -

ExportDataTable Problems

I am attempting to utilize the ExportDataTable method and am coming accros some difficulties.

In some cases it works fine. In others I get type conversion errors.

Most of the Worksheets I am dealing with will have mixed data type contents in a column. I just want to load all the data into a DataTable as text while doing the appropriate conversions, as needed.

Is there a way to specify this in the method call?


-Steven Perry
Tongue Tied

If you use ExportDataTable method, the data type in a column should be same. Otherwise, please try ExportDataTableAsString method.