MS Access SQL to T-SQL Convertor

ms-access, sql-server

Solution

For my queries, I would prefer to do them by hand rather than let a tool do the translation.

I do not know of a tool, but here is a decent cheatsheet

http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/Quick-Access-JET-SQL-to-T-SQL-Cheatsheet.aspx

Problem

Is there a tool that will convert MS Access SQL to T-SQL?

Original source