Member Avatar for mwr

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

  • 2 Contributors
  • 1 Reply
  • 102 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.