Easiest way to convert Microsoft Access SQL code to T-SQL code in SQL Server

[cbalian]

We are currently converting our Microsoft Access reporting to SQL server so we can generate reports out of Crystal Reports instead of Access. Is there a translator or function that you can copy the SQL code of a Query in Access and Paste it into SQL server but have the syntax convert it for you so SQL server can read it?

I mean if we can translate Japanese into German there must be a tool to translate Access SQL to T-SQL.

Thanks
Chad

[Delerna]

This has been asked many times before

Try entering
access to tsql
into the search box at the top of the page.
There are lots of threads on the subject

also there's a difference translating
1 language to another so that a human can read and understand
and
1 language to another so that a computer can read and understand

A human can interpret mis-translations
A computer cannot, or at the very least, it is difficult to make it so that the computer can, in every case.

A translator can only go so far, which is why I personally, prefer to translate them myself...... I know the translated query is doing what I intended it to do and I know each and every query is properly tested.


But that's just my opinion and preference