• Zip Code Radius Tool |
• About Eraserve AP |
• MS Access Tutorials |
• MS Access VBA

Back To Top

MS Access SQL Append Query Example For MS Access versions 2000, 2002, 2003, 2007 Go here to see the Append Query in VBA This is a basic SQL Append Query tutorial, in it we will take the Append Query in MS Access Query Builder and turn it into SQL code.   The above Access Append query is complete. Now all we need to do is Click the View button and Select SQL View.

Once you have clicked "SQL View" you will be presented with a plain white window with the SQL code for your "Append Query". This tool works in reverse provided it is error free. Thus you can use the SQL View to design queries and check them for errors for other uses such as VBA code.

 

 

From here you can run the Query, copy the SQL code or test out any changes you wish to make for other purposes. Other purposes could be testing VBA SQL queries, or for use in other Data Management Systems or whatever you can think of.

That is it; you can now use the SQL View for any Query designed in the Query Builder.

The following is the Code output of the above picture:
INSERT INTO MAIL_CAMPAIGN ( USE, NAME, ADDRESS, CITY, STATE, ZIP )
SELECT CUSTOMERS.USE, CUSTOMERS.NAME, CUSTOMERS.ADDRESS, CUSTOMERS.CITY, CUSTOMERS.STATE, CUSTOMERS.ZIP
FROM CUSTOMERS;


The above SQL Append Query would, if ran, Append all records from my Customers table into my Mail_Campaign table.

You may also wish to see these tutorials:
MS Access Append Query
Update Query Tutorial

For further MS Access tutorials go here: MS Access tutorials

You may post this tutorial on your website or in a forum. If you do please maintain a Link to Eraseve AP.