. How To Convert Access Query To SQL Query?

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

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?

SHARE
Answered By 270 points N/A #200437

. How To Convert Access Query To SQL Query?

qa-featured

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.

Related Questions