Ensure numeric data type in recordset being exported to Excel

[Richard Schollar]

Hi

I run a VBA function in Access that generates an ADO recordset and dumps it out into Excel using CopyFromRecordset method of the Excel range object.

The problem: once pasted into Excel, the numeric components (ie the Value column) is coming thru as Text (and hence I can't sum etc without further processing).

The source of this numeric data is a linked table in Access which links to an Excel sheet (hence I have not at any point specified in Access what the actual data type of this field is). I am presuming that this is the cause of my current problem.

So, is there any way I can enforce a numeric data type for this data, so that is is exported in the correct format?

Note: I don't want any help on how to process the data after it has been exported to Excel - can do this myself if required.

Thanks

EDIT: this has been crossposted here:

http://www.utteraccess.com/forums/s...view=collapsed&sb=5&o=&fpart=&vc=1&PHPSESSID=

 

[Richard Schollar]

Hi

Roger Carlson over at Utter Access solved my problem - simply had to apply CDbl to the numeric fields in their respective SQL statements to cast the data type. All sorted now!