Hello.
I have problem with ADODB.Recordset.
I have query : DRILLTHROUGH SELECT FROM [" + _strCube + "] WHERE (" + strWhereMDX + ")".

Query return a Field.
The field have Type = AdVariant and Value 21.0.
When Add RecordSet to AxOWC10.AxPivotTable is OK.
When i Export Data from OWC to Excel i Excel i have a number value in string.

I nead a type in recordset double no adVarint.
How can i change type in recordset to double from adVarian.
Any help please ..
Thank
Michal

Call recordSet.Fields.Append("name", type) and manually convert the values to the new type