Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries

Показать описание

By Andrew Gould

Рекомендации по теме

Комментарии

This is great. I had done it by creating different modules with each query in it, it still worked but this way is a lot cleaner and simpler. Thanks so much!

FastingDude

Thank you Andrew Sir, I really love your videos and enjoy as well and I always learn new from your videos
Thank you so much, sir
You're awesome sir

pradeeprawatvlogs

Awesome code! Thank you so much for the great and useful tutorial. I have been looking for this code.

lightning

Congratulations for your tutorials these are really helpful...i m wondering if is posible to save the resultsets in a new workbook insteaf of the same!!!!

basilisxytas

Hi Andrew, I attempted using the method you taught in this tutorial to connect to SQLite with multiple queries at once, and sadly it didn't work. I have done a bit research and it seems due to the limitation of SQLite itself. I guess I will have to use command instead. Thanks!

lastdance

Do that work on access? I'm trying without success. Thx for the vid

Edit: on stack overflow, it seems that this operation is not possible for access database :(

johanbaltazar

Thank you very much for great and incredible efforts.
As for results from "Director" table there are some fields that shows errors "Dates and times that are negative or too large show as . How can I adjust that in the results in the worksheet?

KhalilYasser

Thank you very much.
Could you explain to me please why I get an error when I do the loop with several requests.
All the sheets are created, but with this message (sorry in French) : "Erreur d'exécution '91': Variable objet ou variable de bloc With non définie".

frankmanas

Thank you for this beautiful comprehensive video. I was able to connect the database using the excel vba. In addition i was able to create query using WHERE statement also but if I try to pass WHERE statement with variable, it shows error (No value given for one or more required parameters).
"SELECT * FROM Movies WHERE Actor = 'Tome Cruise'" works
but
Dim Actor As Variant;
ActorName = 'Tom Cruise';
"SELECT * FROM Movies WHERE Actor = ActorName'" doesn't.

Kindly help.

bioactiveSaha

Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries

Excel VBA User form part - 1 | Excel VBA lesson 56 | Create Label in vba user form

Excel VBA Introduction Part 57.2 - Basic Web Scraping with Selenium and Google Chrome

Excel 2010 VBA Tutorial 56 ActiveX Controls Drop Down Box

Excel VBA Introduction Part 57.1 - Getting Started with Selenium Basic and Google Chrome

Excel Visual Basic (VBA) for Beginners - Part 1 of 4: Buttons and Macros

Excel VBA Tutorial for Beginners 56 - DatePart , Now , Time, Day , Month, Year Functions in MS Excel

Excel VBA Tutorial 56 - How to Login to Facebook using Excel VBA

5 Best VBA Practices | VBA to Excel | #shorts #vba #excel #automation

Excel VBA User form part - 3 | Excel VBA lesson 58 | Create ComboBox in vba user form

Excel 2021 VBA Beginner Tutorial

Excel VBA Tutorial for Beginners (Part 4/10): The Range Object

Excel VBA User form part - 4 | Excel VBA lesson 59 | Link ComboBox in vba user form | Link ComboBox

Excel Visual Basic (VBA) for Beginners - Part 4 of 4: Loops

Automate Manual Filtering and Reporting - Eliminate Redundant Tasks with VBA 56 MINUTES

Excel VBA Lezione 56

Excel VBA Introduction Part 1 - Getting Started in the VB Editor

Excel Visual Basic (VBA) for Beginners - Part 2 of 4: Change Cell Values

Excel Visual Basic (VBA) for Beginners - Part 3 of 4: Positioning and Offset

Excel VBA Beginner Tutorial

Getting Started With Excel VBA: Step By Step Tutorial For Beginners

4 For Loop HD [Learn Excel VBA (Macro) with Prince]

Excel 2021 VBA Intermediate Tutorial

Excel VBA 4 (highlite cells with color)

56 Dispositionsprogramm in Excel VBA selber erstellen