Importing Data into an Excel Pivot Table via Access

A

Andrew

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
 
D

Debra Dalgleish

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
 
Top