VBA and SQL Server - Add data to SQL Database using VBA. Part-5

Everything you need to know about working with SQL Server using VBA. Most importantly teaches you in layman's term how to use ADO, SQL in your VBA Program to manipulate data in Server.

Subscribe, Like, and Comment. 🙏Thanks for watching.

You can now support by buying any of the Projects or Source Code.

📌What to watch next:

#VbaA2z

[bnancy]

never knew you had these tuts. Thanks for simple explanation, you're the best!

[bigonebikes]

Great videos, thanks for creating these. One note, you don't have to do a select of the table to create a recordset. Just add the table name to the recordset open statement: rst.Open "FlowTb", cnn, adOpenDynamic, adLockOptimistic
That is much more efficient since it's not necessary to bring any records from SQL Server.

[pediechun]

Very helpful and informative tutorial thanks!

[marinlyolyov]

Hello, and thank you for videos in 2:00 you say you will show how to encrypt the database password where can I find that. Thank you. Regards

[vinodnirmala]

Thanks for this video . One Question, i have export the data from excel to SQL Server.next day i want update only one record in the excel sheet and that must be updated in the database.
how can i do this.

[amitrana]

Hi your video is very helpful nd detail, i did create my project with the help of videos.but could you please tell me with 2 code if cell value is blank it will close connection and dont update any data and give error and if data updated tht will delete that specific row nd offset

[scottansir]

You should build enterprise app and sell it. let know if you want to partner :)
You have amazing skills and broad knowledge too.
thanks and cheers!

[ramangupta]

Very much usefull video sir. Can you Please send me the code.