Migrate Access queries to MySQL

I have about 100 queries in an Access 2003 database that I would like to move over to MySQL.  The data is already in MySQL, I just need to move the queries now.  Would would be the best way to accomplish this?  Thank you.
DanielAttardAsked:
Who is Participating?
 
k_murli_krishnaConnect With a Mentor Commented:
Here is the best bet:

Free Software To Convert Sql Query Into Mysql
http://www.softwaregeek.com/free-software-to-convert-sql-query-into-mysql/p1.html

Migrating MS Access queries to MySQL
http://forums.mysql.com/read.php?104,60743,60743

Try using replace all in entire file or selected text in normal/block selection mode in advanced editors like TextPad, EditPad, EditPlus etc. based on:

SELECT Statement (Microsoft Access SQL)
http://msdn.microsoft.com/en-us/library/bb208930.aspx
Access SQL: SELECT clause
http://office.microsoft.com/en-us/access/HA102768991033.aspx
MS ACCESS SELECT - WHERE QUERY
http://www.edumax.com/database-basics-ms-access-select-where-query.html

MySQL SELECT Syntax
http://dev.mysql.com/doc/refman/5.1/en/select.html
A little more on the MySQL SELECT statement
http://www.webdevelopersnotes.com/tutorials/sql/a_little_more_on_the_mysql_select_statement.php3

0
All Courses

From novice to tech pro — start learning today.