Re: Setting EXCEL columns data type

From: solex (solex_at_nowhere.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 09:17:59 -0400

Marilyn,

You might want to post your question in the Excel group. This is an Access
group, and you question is about excel automation, but I can suggest you
look at the excel object model in the excel programming.

Dan

"Marilyn" <Marilyn@discussions.microsoft.com> wrote in message
news:4A633C9B-4211-4F94-AA35-4B5609AE103D@microsoft.com...
> 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.
>
>
>

Loading