Setting EXCEL columns data type

From: Marilyn (Marilyn_at_discussions.microsoft.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 12:57:02 -0700

I am exporting data from ACCESS database to EXCEL. 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 I change the data type of the EXCEL columns before exporting.

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

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