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.
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,
-Ivan