read sql statement of a query using vba

[TSIGOS1]

Hello,
I have created a query in Access and I want to be able to read the sql statement of the query using vba and then run it from excel vba.
That is instead of copying and pasting all the query sql statements i want to use code to read it directly from vba. Or alternatively run from excel the query on a recordset without the sql statement.

Thank in advance
Tsigos

[NeoPa]

Each QueryDef (saved query) object in Access has a .SQL property with (strangely enough) the SQL string in it.
However, you're probably better off running the query remotely from Excel rather than trying to execute the same SQL. Syntax differs and so does the data sources that are available (and how they are referred to).

[TSIGOS1]

I have tried copying the code from access to excel vba and it works fine. No need to convert any references or like *.to % or anything. Since it works any ideas on how to get this code from querydefs???

Thanks again!!

[Denburt]

Since you haven't posted any code I really don't understand the question. I would simply link to the query Via Excel then use something to refresh it or re query in Excel when needed.

[NeoPa]

I have tried copying the code from access to excel vba and it works fine. No need to convert any references or like *.to % or anything. Since it works any ideas on how to get this code from querydefs???

Thanks again!!

Please check out post #2 again. I answer that question as the first sentence (paragraph).

[TSIGOS1]

thanks vey much for the prompt replys
you pointed me directly, i hadn't use .sql statement before but now i figured out how it works.
Excellent job u do.
Thank again

[NeoPa]

Thank you. You're welcome.
It's always nice to be appreciated.