Pivot Table From Access Parameter Query

P

Paul Smith

I would like to built a Pivot which gets it's data from an MS Access
query which requires a parameter, which I would like to pass from
Excel.... is this possible?

if so, could someone please supply some sample code, the issue I am
having problems with is the parameter. I do not want to create the
pivot table or querytable using a SQL string from within Excel, I want
to use the Access Query.

Help or advise would be appreciated....fast [smile]

PWS


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 

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

Passing Parameters to a Pivot Table 1
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Running an Access function (with parameters) from Excel 6
Playing back a Pivot Table macros 2
pivot table to MS Access query 0
Passing Criteria to a Pivot Table from combo boxes 3
Query from Excel to Access - Passing Parameters? 8
Using VBA on Excel Pivot Tables 3

Top