Live SQL Data in Excel | VBA Without Power Query

In this video, you’ll learn how to pull live SQL data directly into Excel using VBA — without Power Query and without manual copy-pasting.

We’ll connect Excel to a SQL Server database, run a query from VBA, and load the results into a worksheet with one click. This approach is ideal for reporting, dashboards, and automation workflows where Excel acts as a front-end to your database.

This tutorial is beginner-friendly, but uses real-world VBA patterns you can reuse in larger tools like CRMs, client portals, and internal reporting systems.

✅ What you’ll learn:

How to connect Excel to SQL Server using VBA

How to pull live SQL data into Excel

How to automate data refresh with a single click

How to avoid Power Query entirely

How to prepare Excel for scalable SQL automation

📌 Next video:
I also have a follow-up tutorial where I build a VBA filter UserForm that replaces multiple SQL queries:
https://youtu.be/YkQlaiC0uZU?si=FP71bsa245OJTEja

📂 Mock database download:
If you want to follow along, the SQL mock data used in this video is linked below.
https://jacobautomation.gumroad.com/l/Vault

👍 If this helps, like & subscribe for more Excel, VBA, SQL, and automation tutorials.

📲 Follow me for daily content on Excel VBA, SQL, Python, and AI automation:

🔗 Instagram: https://www.instagram.com/excel_vba_automation/
🔗 TikTok: https://www.tiktok.com/@jacob.automation
🛠️ Automation tools & templates: https://www.etsy.com/dk-en/shop/ExcelVbaAutomation

Download my FREE Automation Toolkit here:
https://jacobautomation.gumroad.com/l/automationtoolkit
If you're tired of manually copying and pasting SQL query results into Excel, this video is for you. Learn how to connect "microsoft excel" directly to "sql server" using "excel vba" to pull live data with a single click, eliminating tedious manual data transfer. This method leverages "automation" to streamline your workflow, enabling you to use "sql in excel" as a powerful front-end for your "database" without needing Power Query or other special tools. We'll show you how to set up your "microsoft sql" connection and write the few lines of code needed.

Видео Live SQL Data in Excel | VBA Without Power Query канала Jacob Automation