If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing Data into an Excel Pivot Table via Access
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 |
#2
|
|||
|
|||
Hi Andrew,
This is another way of doing it. Extract your data and put them in a spreadsheet and use that spreadsheet as your input to your pivot table. Hope this will work around your problem. "Andrew" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing Excel spreadsheet into Access - data type problem | Andrew Good | General Discussion | 2 | August 27th, 2004 09:39 AM |
Export Pivot Table to Excel Sheet | Suntisuk | Using Forms | 0 | May 28th, 2004 08:56 PM |