By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

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

P: 4
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
Nov 3 '09 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
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
Nov 3 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.