Importing Excel files into SQL Server using DuckDB and Python
Learn to use DuckDB to read data from Excel and then send it to SQL Server with Python and Pandas.
2026-09-02
5,234 reads
Importing Data from Excel
Junk Drawer
Dale Newman created open source project called Junk Drawer. It's goal is to make the majority of Excel or text file importing a one step, no-brainer process without using the Import Wizard.
2014-03-05
3,095 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers