Importing Data into an Excel Pivot Table via Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with this

Thanks

Andrew
 
You can't create a pivot table from a parameter query.

In Access, create a query without parameters, then add the parameters in
MS Query
 
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

Access #Error & Excel Pivot 0
Access query not showing as sources for pivot table 2
pivot tables 1
Automatically Refresh pivot table 6
PIVOT TABLE 3
Pivot tables - Editing the data source shared by multiple pivot ta 1
How do I save Pivot Table Data 4
Pivot Table 2

Back
Top