Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting text data type to numeric
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting time from text to numeric | Excel Worksheet Functions | |||
Converting Numeric values to Text | Excel Worksheet Functions | |||
converting text to numeric data | Excel Worksheet Functions | |||
Converting Text into a Numeric Value and Totalling | Excel Worksheet Functions | |||
Converting Text to Numeric | Excel Programming |