Access query to SQL query converter

Asked By 20 points N/A Posted on -
qa-featured

Hi,

I had an application that uses access database but Now I want to convert my access query in SQL query but I am enable to convert my query.

I need an online Access query to the SQL query converter.

If anybody knows any working URL please send me or any web from which I can use suggest to solve my problem.

SHARE
Best Answer by Cohen Wible
Answered By 5 points N/A #193963

Access query to SQL query converter

qa-featured

It’s good as you want to shift to SQL because SQL query will work with any database without much trouble. I know 1 online tool that will allow you to not only convert MS Access query to SQL query but also to Postgre SQL query allow. You can visit the below link and use the tool it will convert you query 100 % without any trouble.

Best Answer
Best Answer
Answered By 0 points N/A #193964

Access query to SQL query converter

qa-featured

If you will be using Microsoft services for your SQL databases, it would be much easier to migrate or export datasets. In Microsoft Access 2010, there is a "Database Tools" tab where you can export your table SQL Server or Sharepoint. In the section "move data" as seen below, you can see that you can export your database to a number of formats.

Migrating to a MySQL database
 
If you would be migrating to a MySQL database, there is third party software available for your migration needs. There are also instructions on the MySQL website for migration from Access 2000.
 
Hope this helps!

Related Questions