CODEWITHSUNDEEP
sqlexceloledb
kamahl
kamahl

Reputation: 941

Excel SQL Syntax JET OleDB Reference?

I´m querying an Excel Sheet from a .NET Application with an Jet driver.

Are there any ressources on SQL on Excel files covering:

Formats, DataTypes, DataConversions, Supported Statements ... ?

Thank you

Upvotes: 3

Views: 1510

Answers (1)

onedaywhen
onedaywhen

Reputation: 57023

The SQL syntax is the same as for the Access database engine (Jet, whatever) version 4.0 i.e. Access2000 through Access2003.

The way the driver/provider works out data types is a little odd and can be frustrating that you can't just specify what they should be (as you can e.g. for a text file using a schema.ini file). This article I wrote on the subject many moons ago still gets a lot of traffic, read the comments for advanced help.

Upvotes: 1

Related Questions