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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Streamline PivotTable creation code 1
Creating a Pivot Table with a named range 3
Pivot Table Pain! 2
replace PivotCache in PivotTable containing calculated fields 1
Retrieving Pipe (|) delimited text file into ADO Recordset 2
Using WSH to populate a pivot cache with an ADO recordset 4
macro skips a command 4
Re-assigning CommandText to an existing PivotCache 2

Back
Top