Jon Peltier wrote:

Could you populate a VBA array with the recordset data, then loop
through the array to run this:

MyArray(i,j) = Val(MyArray(i,j))

to assure that the array is storing numerical values?

Much easier to do the work on the server to cast the values as numeric.
I don't think the OP advised what the database product is (a DSN hides
so much) but if it is SQL-92 compliant e.g.

SELECT
CAST(my_text_col AS FLOAT) AS converted_numeric_col
FROM vipr_weekly_usage_tmp;

But if it is Jet then use the VBA5 cast functions e.g.

SELECT
CDbl(my_text_col) AS converted_numeric_col
FROM vipr_weekly_usage_tmp;

Jamie.

--