Excel SQL Syntax JET OleDB Reference?

Question

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

Answer 1

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.