Series articles: MS Excel - Connect to a SQL Server database

Use Excel to query SQL Server databases directly and automate reporting.

Follow the "MS Excel - Connect to a SQL Server database" series

They land in your feed reader on their own — no account, no email address, nothing to unsubscribe from. Paste this URL into your reader:

https://www.avonture.be/series/ms-excel-connect-to-a-sql-server-database/rss.xml

Add to Feedly Add to Inoreader Open in my reader

No feed reader yet? Start here — it takes two minutes.

Microsoft Excel

MS Excel - Connect to a SQL Server database, run a query and get the results - Step by step →

Connect MS Excel VBA to SQL Server with this step-by-step tutorial. Learn to run SQL queries, retrieve data, and output results into your spreadsheet. Docker setup included.

March 16, 2025

Microsoft Excel

MS Excel - Connect to a SQL Server database, run a query and get the results →

Connect MS Excel to SQL Server with VBA. Run SQL queries, inject results directly into your spreadsheet, and preserve formatting. Learn the best method for data refresh or secure sharing.

April 5, 2024