. How To Convert Access Query To SQL Query?

Asked By Tiana Berry 0 points N/A Posted on - 09/13/2016

I want to convert the query I created in access using the wizard that query need to be typed as a program in SQL query. Is that possible to convert access query to SQL?

• Status: Open
• Question Views: 436
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Waall Mike 270 points N/A #200437

. How To Convert Access Query To SQL Query?

To convert the Access query to SQL you need to follow the given below.

Step 1: Open Access and Run the recordholding the query that is to be rehabilitated to SQL

Step 2: Open the designated query in Design View

Step 3: Select View from the menu and select "SQL View" 

Step 4: The SQL query is then to be copied from that place and to be pasted where ever required.

About Waall Mike

Questions
20

Answers
220

Best Answers
62

• Vote Up 0 Vote Down

• Posted on - 09/13/2016
• Question Category: MS SQL Server