Get EXCEL data using SQL in VBA!

Published: 21 September 2022
on channel: SimpleExcelVBA

30,888

194

There are tons of ways to get the data from Excel worksheet. In this video I’m going to show You how to query Excel data using SQL in VBA.

CODE from video:
https://simpleexcelvba.com/connect-to...

PREVIOUS VIDEO:
○ Get data using ListObject: • How to get data from Excel table using Lis...

TIME STAMPS:
0:00 Intro
0:25 Mix SQL & VBA
1:14 Project References
1:33 Sample data
1:50 Exercise
2:12 Function
2:38 SQL string query
3:23 Connection string
3:52 ADODB recordset
4:17 Outcome
5:39 Thank You for watching!

SITE & SOCIALS:
○ Website: https://simpleexcelvba.com/
○ Facebook: / simpleexcelvba
○ Buy me a coffee: https://www.buymeacoffee.com/SimpleEx...

CONTACT:
tomasz@simpleexcelvba.com

Don't forget to leave like and subscribe to my channel, it means a lot to me :)

On this page of the site you can watch the video online Get EXCEL data using SQL in VBA! with a duration of hours minute second in good quality, which was uploaded by the user SimpleExcelVBA 21 September 2022, share the link with friends and acquaintances, this video has already been watched 30,888 times on youtube and it was liked by 194 viewers. Enjoy your viewing!

481

00:00:00