Query Excel or CSV files with T-SQL

Federico Di Marco

Rate me:

4.70/5 (4 votes)

24 Oct 2023CPOL5 min read

7.1K

Query Excel or CSV files with T-SQL without importing them in a table first

This article is a tutorial on how to query Excel or CSV files through T-SQL without first importing them into a table.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Federico Di Marco

Software Developer (Senior)

Italy

I'm a senior .NET software engineer in the second half of my forties. Started using a computer at six years, gone through logo, basic, assembly, C/C++, java and finally to .NET and .NET core. Proficient also in databases, especially Sql Server and reporting. Let's say I have also some experience on security but mainly in the past, now things have become much more difficult and I do not have too much time to keep me updated, but sometimes I am still kicking in. Fan of videogames, technologies, motorbikes, travelling and comedy.

Email: Federico Di Marco <fededim@gmail.com>
Linkedin: LinkedIn
Github: GitHub
Stackoverflow: StackOverflow

Query Excel or CSV files with T-SQL

Views

Downloads

License

Comments and Discussions