Use this page to convert Access queries to SQL Server Transact-SQL objects.
Access QueryDefs are listed on the left side of the Query Page and selected QueryDefs are shown on the right.
Use the multiple-selection list-box and arrow buttons to select and de-select QueryDef entries. Be sure to check that your desired options are in effect.
Press the Convert QueryDefs button to start the conversion process. The Status Page is displayed.
Note that only queries in the QueryDef collection can be converted to SQL Server. See Converting Form and Report SQL.
Use the Query Type buttons to display and select the queries you wish to convert.
Displays all QueryDefs. Queries listed in the Selected Listbox will be converted when the Execute button is pressed.
Displays Select, Crosstab, and Union queries.
Displays Append queries.
Displays Make Table queries.
Displays Update queries.
Displays Delete queries.