Integrate Excel, VBA and SQL. Simplified and powerful

Simplified tutorial, how to Integrate Excel, VBA and SQL. Simplified and powerful

Please like, share and comment to improve channel algorithm

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

📌What to watch next:

#VbaA2z

[linnick]

Sir you’ve no idea how much all these videos have helped me at work. Thanks much.. Stay blessed!

[matnz]

This is best and most detailed VBA SQL tutorial I have come across. Thank you so much

[hoseal]

Yours is the best VBA YouTube channel!!!
Keep it up!

[scottansir]

You're the best mentor. Thanks Pamai.

[shellynomis]

Best tutorial, processional and practical indeed

[bnancy]

Very simplified and easy to follow. thanks as always, appreciate your efforts!

[pekidonn]

This is brilliant. Thanks for another useful video.

[azel]

Thanks for another cool video.
Never knew about this.

[melivo]

Thanks for this useful video. Please show how to compare 2 tables and return the differences and also find the variance between 2 tables

[holieh]

Thank you for another great tutorial. Keep going

[shaiknagulmeera]

Thank you for sharing your knowledge with all of us and I really appreciate it.
Can you please make one complete video related to Excel to power point automation. Thanks

[Rahul-snwn]

Thank you soo much sir. You’re awesome

[DAXifiedSatish]

Hi, I am facing an issue hope you can help me out. I have 2 connection and I am getting data from sharepoint list.
I want to make final data output based on inner join of both these list. I tried but unbale to join these tables. In your example there is single connection but as I am retrieving two lists so I have two connections. Can u guide be as I can't go ahead without inner join.

[kinga]

Excellent tutorials!
Can we work with password protected excel file too? Doesn’t work for me when locked.
Please share example of how to delete records too. Thanks.

[imranbhatti]

Great video Pamai. Would you please let us know how we can use SQL within a workbook? i.e. the source is not a separate workbook but it a sheet within the workbook itself .

[shadow_gaming_sk]

Can you please prepare the series basic to advanced

[sktneer]

While using a SQL statement within the rs.Open method, you need to use the argument CommandType as "adCmdText" instead of "adCmdTable".

[KhalilYasser]

Thanks a lot for this masterpiece of the tutorial. Can you please share the VBA codes?

[bigE]

Is there a way to use ADO to write data from one workbook into another? If not is there a way to write data to a closed workbook using a connection from another Excel workbook?

[shadow_gaming_sk]

Hi I want online training training from you