I am exporting data from ACCESS 2000 database to EXCEL via ACCESS VBA. The
datasource is a query.
There are numeric fields in the query but after exporting, the numeric data type is changed to text.

How do programmaticaly change the data type of the EXCEL columns.

I'm using the following statement after loading the data into an array.


oSheet.Range("A2").Resize(irows, icol).Value = vArray
vArray is defined as variant.