Excel VBA Introduction Part 56.5 - Basic ADO Commands

By Andrew Gould

[szewing]

I have been watching your videos for 4 years. They are really helpful.
I really appreciate your work.

[g-cf]

Your videos are the most helpful ones to me. I have been watching for several years and used your techniques at my workplace. I have created many useful automation files, thank you very much.

[MyAudioBookCompilation]

Thank you once again. Just found the answer to my question.

[rajeshmajumdar]

Thank you Andrew! You are my Guru ... wonderful work!

[KhalilYasser]

Thank you very much for continuous wonderful videos

[sashatv]

Wonderful! Thank you, Andrew!!! You are brilliant as always!

[efernandes]

Wonderful set of videos! Can you tell me the best approach to insert or update records in the Film table if your using drop down list to enter the FK fields like Director, Genre, etc?

[chandankumar-npez]

Hi Sir,

Thank you for all your videos.

Kindly make a video how can we extract dump from Avaya CMS using VBA code

[FSWEB]

Great videos!
Question, you advise on video to install OLE driver...for excel connection to SQL server, is that needed?
I was under the impression excel can connect to SQL server without any additional software, just plain ADO.
Thanks

[noorsalh]

Hi,
Very clear and helpful.
I am trying to follow your way to open communication with SQL database through VBA code of FactoryTalk SE HMI. I am facing an error "SQL server network interface: connecting string is not valid" any suggestion?

Also My database is located on different Pc its not local, is there any place that I need to edit to point to my SQL server PC ?

Thank you and appreciate your support in advance

[PankajNegi]

Great Sir I really enjoy this training session and exciting for another session
thanks for your guidance that I make my project. My project is A data entry form where my team entry or update there records in excel sheet and its save data in my remote SQL server. I am using 'MSOLEDBSQL' provider its working perfect in my system but when I run another system showing error 'Run time error 3706 - Provider cannot be found. It may not be properly install '. if possible how can i fix its Now I have 2 questions first 1 - I want to enter multiple Entries in my SQL database from excel sheet using loop. Second is how to make such criteria like my entries only updated by me or i can not change another entries means no one can change other ones entries only they change own enters how to make this type criteria whenever everyone have to access to see other rights.