run an Access Query From Excel..

**HAWESDS84** · 03-10-2008, 06:17 AM

Hi,

I am terrible at VB....you could say awful!!

I really want to create a macro in Excel that runs a query I have set up in Access - with the capability to also change the date fields within the Access query itself i.e. the Access query has a date range field that I would like to be able to run directly from Excel.

What I would then like the macro to do is to run the query and paste all the data into a sheet in Excel, just a blank one.

Is this possible?

I have read so many threads on similar things - but just can't get my head around it..... I really should learn to use VB properly!!

Does anyone have any code that does something similar?

**Macdave_19** · 03-10-2008, 06:25 AM

I ahev a query i use to pull the data through:

Please Login or Register  to view this content.

Make sure you select tools>references in the VBA editor and enable "Microsoft DAO 3.6 Object Library" or it wont work dude

Just adapt it to suit your needs.

HTH Dude