Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)

By Andrew Gould

You can download the files needed for the video here:

[charlesajouri]

By far, the best instructor, most comprehensive knowledge on the subject matters. Thank you for sharing your gift & knowledge.
Have not seen new material lately. Hope you are well.

[EricsonSWeah]

Andrew, I have not found any better teacher : You are the best!!

[chuchaqui]

You're amazing Andrew!! I have been watching all your videos for the past year and I have grown exponentially in my coding capabilities! Keep up the amazing and work and THANK YOU!

[remolapenna]

Excellent training videos ... you are well organized and provide good examples and are very articulate. I appreciate all the work you
put in towards making these videos.

[diegoalias]

Very Helpful! I've used these ADODB tutorial for sharepoint Lists. So good!

[pradeeprawatvlogs]

Wow Sir, this is an informative video which blows my mind and the content which is in this video is something which I even can't imagine especially drop statement in cells that's a fantastic superb
thank you so much sir again

[abhishekgawde]

Simply amazing Andrew! The detail you go through in each and every videos is really praise worthy. Also i really love the enthusiasm with which explain the concepts. :) you truly are a gem!
in other videos tutorials for any other subjects, i get easily distracted even if they are for a couple of minutes. but these videos i can watch for hours :)

[lonelybard]

Thank you very much for these tutorials! I've been watching them for days. btw, deleting the awful movie was very instructive xD

[niallmorgan]

Great video.  Was able to get it working on my database. Thanks.

[soodashishr]

Sir waiting for new videos upload on Excel VBA series. Please let us know by when new series would be uploaded.

I have learned a lot by watching your video. Thanks a lot.

[helalahmed]

Looking forward to your response- thank you

[jacobsperry]

So glad to have found your videos. They are excellent and thanks for sharing so much knowledge. I'm following along at home and getting a very odd problem around minute 41-42. My access database isn't letting me execute the first query in the loop: "INSERT INTO tblFilm (FilmID, FilmName, FilmReleaseDate, FilmRunTimeMinutes) VALUES (
(SELECT max(FilmID) FROM tblFilm) + 1, 'Marvel''s The Avengers', '2012-05-04', 143)".

If I change the subquery (SELECT max(FilmID) FROM tblFilm) it works just fine. And if I run the main query with a given number (999 for instance), the query also runs just fine. I didn't have any issues with the recordsets in the prior videos. It may be related: but I can't execute the queries into the Access database without a FilmID (that is, the autoincrement isn't working).

Any ideas what I'm doing wrong?

[johnsalkeld]

In the error handler you can clear the terror after the message and resume above the exits sib so that you close the connection in only one place and also exit only once

[s.mal-amin]

Your Tutorials are awesome. This is from Bangladesh. Please add subtitle. I helps us to understand more. Again i say Your all movie are most usefull.

[jerhummemarcelo]

good morning wiseowl, thanks for the great video it was very helpful in learning using sql statements with activex data objects. I would like to ask how to code the insert query to be able to insert data in a single field coming from two textbox controls. just like concatenating the two controls to store in a single field in a database properly. I would appreciate your response regarding my query about the insert query.

[ruteoliveira]

Hello Andrew, thank for these tutorials.I have a question, is possible incorporate na Application, InputBox in the VALUES?

[sakmsb]

Hi, Awesome videos on ADO... Made my life easier at work... Thanks for all of your Awesome videos... Are you planning on releasing videos on ADOX? And is ADOX better than ADO in excel?

[sandeep]

Hi WiseOwlTutorials Awesome videos to learn more thanks a lot sharing.
i have one question: Are we able to connect the sql which is available in (IP Address) Server. if yes please let me know how we can do it???
Thanks in advance.

[aniapirc]

Grateful for the video, really helpful! Thank you!

Please be so kind and help me figure this out:

- lets say, instead of FilmTime as Integer, where numbers are whole, my excel table has decimal numbers. Data type in SQL is set to decimals (30, 28, not null), so naturally FilmTime as integer is blocking my decimals..

My questions is, what data type in VBA should I set my FilmTime as? and what format in values? any suggestions?

[turboq]

Hi Andrew,
your content is gold! I have learned more in 2 hours with your tutorials than in months on my own! The seemingly trivial, small things that you do are quite a discoveries to me (-I've been doing this wrong all this time....). I'm definitely donating you a few £ for these brilliant tutorials :)

One question though, if I would write a function which would query the database and return a recordset - how to go about closing the connection? I mean, if I close the connection within the function, before returning the recordset I invalidate the recordset, right?