During the AccessUserGroups – ET session this morning, one of our attendees provided a link to a new tool being offered by AccessUserGroups.org which converts Access SQL to T-SQL or to VBA code. You can try this tool out at:
This tool does a very good job of translating Access (Jet) SQL into either VBA (creates a string similar to: strSQL = “SELECT * FROM yourTable”
or T-SQL. Strongly encourage you to add this tool to your developer toolkit.