Set a PivotCache as the results of a query

  • Thread starter Thread starter tod
  • Start date Start date
T

tod

Can someone tell me how to set the PivotCache as the result of an ADO
query? So instead of returning a Recordset, I'd like to put the
results of the query directly into a PivotCache.

tod
 
Why are you using ADO. You don't need ADO to retrieve information from a
Database.

Have you tried building the pivot table manually using an external source
with the macro recorder on?
 
Back
Top