query excel with sql

Question

Using MS Office+VBA (or, sometimes, Visual Studio 2010) I am looking for a way to query Excel-Files using only SQL Query, similar to this way of querying a textfile:

SELECT * FROM [Text;DATABASE=L:\Testfiles].test1.csv

As a result I would expect something like:

SELECT * FROM [Excel File=L:\Testfiles\test2.xls].[sheet1$A1:B1000]

I am not looking for a way to query Excel-Files with SQL and a ADODB-connection string (as depicted on connectionstrings.com or here on so.com), since I want all information regarding the data source inside the actual SQL-Code, and not split up between SQL and the connection setup in VB/VBA.

Any hints would be greatly appreciated.

Regards Martin

Sergey S. · Accepted Answer · 2016-08-22 11:21:12Z

2

You can use FROM clause like this:

FROM [sheet1$A3:E22] IN 'C:\path\MyFile.xlsx' [Excel 12.0;HDR=YES;IMEX=0]

answered Aug 22, 2016 at 11:21

Sergey S.

6,3461 gold badge17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Martin Dreher Over a year ago

Excellent. I know I saw something like that before. Many thanks Sergey!

Patrick Honorez Over a year ago

Works perfectly in an Access query

Collectives™ on Stack Overflow

query excel with sql

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related