Can vba run a access query from excel?

[pedie]

Hi, can vba run a access query from excel? if yes, please show me an example code...
Thanks in advance!

 

[meldoc]

Hi Pedie

Is it This.

http://www.access-programmers.co.uk/forums/showthread.php?t=111290

 

[pedie]

Perfect! yes! Thank you, thank you

 

[Norie]

pedie

What type of query is it you want to run?

 

[pedie]

Norie, the query name is "Query1"
This query delete records in database when certain conditions are met.
Any advice from your side too?

 

[Norie]

pedie

That's what I wanted to know - it's an action query.

ie it does something, not just returns records

So it is a quey that's 'executed'.

One thing I don't quite get though is why create an instance of Access just to run a query/macro.

You could get the same results using DAO or ADO.

Just kind of a personal opinion though.

 

[pedie]

Norie, i always try to know different ways so that when things come my ways...then i still dont get caught up...
'm not doing anything as such as of now but when there is something i always do that is often update data to access base then sometime needs to delete some of them again so which i have to open the access file and then delete and close it back....so thats why.

Thanks again
Pedie

 

[Norie]

pedie

So why do you need any code?

 

[pedie]

Can we do that without any code? running access query from excel? maybe 'm confused too..

 

[Norie]

pedie

That wasn't what I was saying.

Perhaps I misunderstood but I thought you were saying you were opening Access and some point.

i have to open the access file and then delete and close it back

I was suggesting if that's what you were doing why not just run the query then.