Andrew, you're the best! We can't thank you enough for all the wonderful videos. Hopefully, some day in the future, you'll add manipulating Excel Tables via VBA in your collection. A million THANKS!!!
Thx a lot Andrew! Perfect as always! I am pretty sure this entire series is the best one about Excel VBA that you can find on YT (not to mention your other series!). I hope you will keep doing your work!
Hello Andrew , I'm wondering if we can create the "Tables View" itself either on Access or SQL Server by VBA ? is it something we can do? if yes.. please advise how ?
Hello Andrew, Thank you for all the great videos. You do an awesome job. What is the difference when one automates with ADO vs Excel connection feature?
Hey Andrew, i've been following this series for a while now and i love it, but with this video i'm struggling. I'm using Excel 365 and when i have to make the connection to the SQL database i get a totally different interface. I can get a query to the tblFilm, but not a connection to the database, i don't get the data connection wizard like u do, i get power query instead. I'm novice at SQL i know that , but the database is set up, the problem is in excel i think, can u point me in the right direction?
Hi Jef, yes the old data connection wizards are disabled by default in modern versions of Excel. Fortunately, you can still find them! 1) From the ribbon choose File | Options 2) Select the Data page on the left 3) Check the box for Enable SQL Server (Legacy) 4) Click OK 5) From the ribbon choose Data | Get Data | Legacy Wizards | From SQL Server (Legacy) I hope that helps!
Andrew, you're the best! We can't thank you enough for all the wonderful videos. Hopefully, some day in the future, you'll add manipulating Excel Tables via VBA in your collection. A million THANKS!!!
Thx a lot Andrew! Perfect as always! I am pretty sure this entire series is the best one about Excel VBA that you can find on YT (not to mention your other series!). I hope you will keep doing your work!
Thank you so much Andrew Sir literally you're an awesome fantastic Teacher in the world for me
Thank you, Pradeep!
Hello Andrew , I'm wondering if we can create the "Tables View" itself either on Access or SQL Server by VBA ? is it something we can do? if yes.. please advise how ?
Hello Andrew, Thank you for all the great videos. You do an awesome job. What is the difference when one automates with ADO vs Excel connection feature?
superb!
Awesome!
Hey Andrew, i've been following this series for a while now and i love it, but with this video i'm struggling. I'm using Excel 365 and when i have to make the connection to the SQL database i get a totally different interface. I can get a query to the tblFilm, but not a connection to the database, i don't get the data connection wizard like u do, i get power query instead. I'm novice at SQL i know that , but the database is set up, the problem is in excel i think, can u point me in the right direction?
Hi Jef, yes the old data connection wizards are disabled by default in modern versions of Excel. Fortunately, you can still find them!
1) From the ribbon choose File | Options
2) Select the Data page on the left
3) Check the box for Enable SQL Server (Legacy)
4) Click OK
5) From the ribbon choose Data | Get Data | Legacy Wizards | From SQL Server (Legacy)
I hope that helps!
@@WiseOwlTutorials Thanks, i did somehow manage to get it to work, but this is much simpler thanks again