Any good SQL Editors out there?

[Guest]

Hello all.

Any Decent SQL Editors out there that will clean up the way access lumps SQL
together and makes for easy editing?

 

[Michael Gramelspacher]

Hello all.

Any Decent SQL Editors out there that will clean up the way access lumps SQL
together and makes for easy editing?

Look at this:

http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl

If you copy the formated SQL back into Access, it will get mangled again when
the query is saved.

This formater requires that Access [ ]. formating od derived tables first be
changed to parenthesis.