Conversion of MS Access queries to SQL queries

[raonhassan]

Hi All,
Anyone knows of a utility or software that will convert MS Access
queries to SQL Queries. I need to convert my existing ms access
queries to SQL queries as i need to use them in a software which only
takes SQL queries. I tried to copy and paste "SQLVIEW" of the queries
from MSaccess but they dont' work as they require modifications.
I don't have much knowledge of SQL queries, wondering if someone can
point me in right direction.

Thx

 

[Michael Gramelspacher]

Hi All,
Anyone knows of a utility or software that will convert MS Access
queries to SQL Queries. I need to convert my existing ms access
queries to SQL queries as i need to use them in a software which only
takes SQL queries. I tried to copy and paste "SQLVIEW" of the queries
from MSaccess but they dont' work as they require modifications.
I don't have much knowledge of SQL queries, wondering if someone can
point me in right direction.

Thx

Unless someone comes through with a tool to convert queries from Access SQL to
SQL Server SQL, you will need to do it yourself. Maybe post one of the SQL
here and see if anyone can convert it for you. Then you can learn by example.
Just an idea.

Maybe someone will suggest a more appropriate user group for your question.