Import query having parameters from excel

[scorpion99]

Hello,
I have a query in access that asks about DateFrom and DateTo as Parameters once executed.
Now , I want to import this query in excel but I need to create two cells named From , To and a button named Submit where I can enter the values above and got the results.Probably it is a VBA codin, can anyone help?

[June7]

You want to export an Access query to an Excel workbook? The query has DateFrom and DateTo as parameters under a date field to filter the records? You want those two values in worksheet cells?

Try this query:

SELECT *, [enter date from] As DateFrom, [enter date to] As DateTo FROM table WHERE [date field] BETWEEN [enter date from] AND [enter date to];

I recommend the parameters be reference to controls on form to better manage input validation. I never use dynamic parameter input popup.