August 9th, 2022

VBA 2010 – 075: SQL INSERT

How to insert new database records using VBA in excel.

Download the samples for this series for free!

All our tutorial samples are free however if you appreciate our work and would like to make a voluntary donation then please do.

Recommended Reading

Both the below books by John Walkenbach are fantastic books and he is a brilliant author, I would recommend picking one of these books up even if just for a reference. I have read power programming cover to cover and it is easy to follow and is a must have for any serious VBA programmer.

If you have read any books and feel they are worth recommending then please post about them on our Forum.

VBA 2010 – 074: Multiple Records

VBA 2010 – 076: SQL DELETE

One Comment

  1. Ivan Nogueira
    May 28, 2016

    Hello Matthew.

    How do I go about inserting columns of data, or even an entire table from Excel into another table in Access? I was able to create a table and its fields, but couldn’t get a table into another. I am afraid I am missing something in my SQL syntax and Recordset arrangement.

    Planning a tutorial on this subject?

    Thanks for all of your work!

    Best regards,


Leave a Reply to Ivan Nogueira Cancel reply

Your email address will not be published. Required fields are marked *