Allan Watkins wrote: a DataTable gets fully populated That sounds like a bad idea; there's no need to have more than one record in memory at a time. Allan Watkins wrote: cannot be converted Sounds like you may need to specify a Parse routine. Take a look at the values that are causing the trouble -- it's possible that they are empty.

Keep your column in an numeric format OR convert it manually in numeric format so it dont create destruction.