Home Connect access query to excel with dynamic input parameter
Reply: 0

Connect access query to excel with dynamic input parameter

user446
1#
user446 Published in April 20, 2018, 10:51 am

I've got some queries I have connected to an excel sheet that I refresh in order to get the latest data.

Is it possible to make excel "ask" for input parameters for one column lets say?

I am looking to get data by company so wondering if it's possible to do it as in access (type [company]:) in the field criteria

If I save the query like that in access it won't let me connect it to excel

Thanks

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.303296 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO