Stored queries

[jkainth]

I have an access db 2003. I have a few tables and a few queries. I am using VBA in excel and need to get some data.

Since my queries are quite long and complicated, i as wondering is there a way to call/run a select query that is stored in ms access via ADO?

 

[WayneRyan]

jk,

Don't use Excel. How about opening a recordset? That should be simple
enough.

Just use the Search Facility here and look for Recordset, you should find
some examples.

Wayne