Getting the raw SQL from an access query to excel

[UWTechie]

When you link an access query to an excel sheet(i.e. using MS Query), is there some way to transport the actual sql over, and put it on another page? I know that I could just copy and paste, but I would like to know if there is some sort of automated way to get it sent over.

Also, once it is transferred, is there some way to run the actual query right from excel, thus eliminating the need to know where the original .mdb is (i.e. the thing still works if the .mdb is moved or renamed).

Thanx

 

[Databaseguy]

Use the SQL property of the QueryDef Object

Dim DBS as database
Dim qdef as QueryDef
Dim strSQL
Set dbs = currentdb()
Set qdef = dbs.querydefs("YourQuery&quot
strSQL = qdef.SQL' You've got your SQL now in a variable
Set everything = nothing, etc etc



Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[UWTechie]

Where do I use this from? I am pretty new with Excel and I know very little (as in next to nothing) about VBA...
I was looking through the online help books, but there was nothing about this kind of stuff there...
Could you please be a bit more explicit in what I need to do?

Thank you very much