Run Access query using SQL in VBA

Hello,

I have an Access query that I am trying to run and then have the output of that data go to an excel spreadhseet. I know there are ways to do it with importing the entirety of the output, but I would like specifics within that query, therefore I need to use SQL code. Does anyone know how to import Access using the SQL data into excel using a VBA code?


Thank you!!

Quick additional info:

Let's call the code I have SQLCode1
The location in excel I want to paste it: Cell A5 in Sheet "DataHub"
The location: "C:\Generic\Generic.mdb"
And the query name called QueryA

Thanks!

Like for example, the query in itself is too large for excel, to just import the entire query results. So I am trying to import based on the state I am working with. I.e. I want to import QueryA, which gives me info on state specific items, for each state and I want it to just bring back the results for TX.

I hope that makes sense.

Yeah, the query has a where for the state. The problem is that it is going to be variable. So once I am able to find code that works, I was going to make it point to a variable cell that already has the desired state selected.

This button is for a mass use by analysts on my team. Once I get the data, I am pasting it in a specific section on a template that then does a lot of other things (that I already have completed) based on that data.

So my final step is getting this data imported from Access pulling in just the State information I want from Access.

I hope that wasn't confusing, but outside of giving company specifics, that's the best way to describe it using the generalities I'm required to.

Thank you so much for taking interest and trying to help.

Alright, thanks. I will have a look around Google and try and find something that works for me using one of those.

Thanks for the interest in my issue.