The Notorious INSERT INTO SQL Statement - Nifty Access
The insert INTO SQL Statement can be difficult to master. I demonstrate a methodical approach which simplifies the task. I also provide a video by way of explanation, and also a sample database you can download.
The secret is to keep the the SQL Statement as simple as possible by constructing it from individual elements, (separate string variables). Then concatenating these string variables together to form the "Insert INTO SQL Statement". Divide and conquer is the rule, by dividing the potentially complex insert into SQL statement in to separate string variables, you simplify the process, you duplicate the process, in the sense that the process becomes a set of identical steps. This is less prone to error and much easier on the grey matter!
The code snippet shown in this product description is available in text form on my website here:- INSERT INTO SQL Statement where you can copy and paste it into your MS Access database...