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...
You've purchased this product
See it in your libraryView in Library
We charged your card and sent you a receipt
You'll need an account to access this in our app. Please create a password to continue.
Download from the App Store or text yourself a link to the app
Good news! Since you already have a Gumroad account, it's also been added to your library.