Office 2010 Activation Running an Access Parameter

Excel MVP Michael Alexander wanted to share this tip about running an Access parameter query from Excel. He describes the problem thusly: An Access parameter query is a kind of interactive query that prompts you for criteria before the query is run. Parameter queries are useful when you need to ask the query different questions using different criteria each time you run it. Now we all know you can pull data from Access into Excel using MS Query. The problem is that MS Query doesn't let you pull in Parameter queries. There may be a technical reason for this,Office 2010 Activation, but I like to think it's just Microsoft's way of keeping things interesting. After all,Microsoft Office 2010 Professional, technical roadblocks are the spice of life.
If you've had enough spice,Windows 7 64 Bit, I'll show you a VBA workaround that will enable you to run an Access parameter query from Excel. Click over to Michael’s blog to learn about his solution to the problem. Send your Power Tips to Mike and Chris at accpower@microsoft.com. <div