Excel VBA Introduction Part 56.1 - Connect to SQL Server using ADO and the MSOLEDBSQL Driver

By Andrew Gould

[pollipudlipotty]

This was great, the video helps me in my work. Thanks!

[soalanmedia]

Thanks for your video, its very helpful for my work.

[dineshkumarachari]

can you please create video for VBA connect to oracle sql developer database with using option service name, hostname and more

[manjuanth]

Could you please help me out connection reflection session

[vinayupadhayay]

How to copy from Microsoft access passsword protected table from vba

[OrangeBossa]

Thank you very much for these excellent tutorial videos! Got a question at 2:50, once you check the box for a library and click OK, next time when you open Excel and VBE, do you need to make the reference setting again? What about you send your Excel workbook for someone else to use, will Excel remember the setting, if not, where does it store the setting? Thanks!!

[gayathrie]

The video was really helpful. Can we connect to Azure Devops through macro? What provider should we need to use?

[joshuakilian]

Thank you so much for Part 56! This has helped me so much with setting up a User Frontend on Excel with SQL Server Express! I am wanting to eventually take the Database online to allow colleagues to add data and generate reports using the Excel Frontend. However, I am unsure of how to use the ADO connection to connect to this online remote server. Do you have any readings or knowledge on how to achieve this? Thank you again!

[Seema-vlgb]

CopyFromRecordset is used for vba excel. I am writing same in vba word. Pls help me how can I fetch the record

[barrysmith]

How do I write the string so the user gets an Azure AD Prompt to sign in and then allows access to the specified Azure SQL Server??? I've tried Authentication=ActiveDirectoryInteractive, but it gives me an error about not being federated...

[krn]

Thanks Andrew. Are you going to watch the Yankees vs Red Sox today in London?

[noorsalh]

Hello,
Thanks for those powerful videos.

I am trying to use your method to connect to SQL server via VBA code in my FactoryTalk SE HMI. However, i am getting this error " SQL server network interface: connecting string is not valid [87]" any suggestion ??

Q2: my SQL server is not local, how can VBA communicate with the SQL ?

Thanks and appreciate your support in advance.

[rks]

As a Indian how can I join your self paced classes.

[juanpablohorn]

Does the old code of part 30-32 work with the new driver?

[jayjayf]

I have a question; do you think VBA will become obsolete? Because I don't want to spend a lot of time learning, and find out time has been wasted.