In access, open the query in design view the go to the view menu and select
sql view.

You can also set up an odbc data source and go to control panel, admin
tools, odbc admin and set up tracing.

You asked for it. ;-)

As you requested *any* hint, I suggest you look into how to access the
system table "MSysQueries", and possibly some other as well, as the
"MSysQueries" mostly isn't built up as scripts like stored procedures, but
with relations defined by the query editor...

Hint, hint...

Now, the tricky part should be how to access that system table from Java...

I believe I saw some hack in C++ a couple of years ago that could accomplish
this by some low level access to some native API, don't ask me where I saw
it...

// Bjorn A

If you have only a few QuerySQL, the quicker wayis to copy all sql
manually in MS Access.
If you need a program solution, you can use HXTT
Access(http://www.hxtt.com/access.html), a commerical JDBCdriver for MS
Access.

ResultSet rs=dbmd.getTables("adb",null ,null, new String[]{"VIEW"});
while(rs.next()){
    String viewName=rs.get("table_name");
    String sql=rs.get("remarks");
    //...
}