Importing Access query into Excel:Microsoft Query

**ge0rge** · 04-02-2009, 09:13 AM

I am using the excel to pull in an access query. I can make it work ok. The problem is I am trying to import a query that if using access asks for a start date and end date. When I try to import this query I get the following error:

Microsoft Query:
Too few parameters. Expected 2.

How do I set the parameters within excel so when I try to pull the data it will work or give me the option of selecting a date range? This is my routine for doing the import in excel: Data, Import External Data, New Database Query.

Thanks for looking!!!

**Macdave_19** · 04-02-2009, 09:19 AM

Do the dates connstatly change or are they open to whatever you want to pull through?

**Macdave_19** · 04-02-2009, 09:24 AM

You could adapat the following code which uses SQL:

Please Login or Register  to view this content.

If you're familiar with SQL it'll be easy but if not i can try and help

also you'd probably want to add a reference each one of the two dates so the Code pulls through the right Data.

oh yeah you'll aslo need to ad the reference Microsoft DAO 3.6 Object libarary for it to work

**ge0rge** · 04-02-2009, 10:51 AM

The dates will change. I don't know sql either. Would I just have to change some of the references in your code to give it a go? I tried this method:
http://www.dailydoseofexcel.com/arch...-data-queries/
but I don't get this area: Between [Enter a start date] And [Enter an end date]. Thanks for helping.