Uncertain what Access query type to use for Excel external data pull
Posted on 2014-04-10
all '10 products.
I need my Excel to pull into a pivot table the results of a query in Access. I'd rather not have to run the query and make a table, but rather have the query set up, and when needed by Excel, get the information pulled. been a while since I've used Access or external data in Excel. Here is where I'm falling:
- what type of query should I be setting up in Access (seems there are many more than when I used to used it)
- in Excel, I'm not finding the ability to pick a query name when opening my external connection to Access...does this mean I can ONLY run a query to make a table, have it stored in Access, and then reference that table with Excel?
Most importantly, I noticed the ability to enter parameters into Access queries. Is there a way to drive that parameter with a cell in Excel? That's what I ultimately need. I have a large DB of financial results, with project codes. I have a list of project code owners. I need to have an Excel file which references that data and only pulls in the data that's relevant for the person for whom that file is being created (and put it into a PT format, for manipulating the view).
Thanks for what hopefully doesn't come across as too newbie in this forum.