3

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

kamahl
  • 931
  • 1
  • 8
  • 20

1 Answers1

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.

onedaywhen
  • 55,269
  • 12
  • 100
  • 138
  • thank you, it´s a good starting point Maybe i´m not finding something in the referance, but how can i cast strings to dates? – kamahl Sep 06 '11 at 12:03
  • Found a solution for my question in c# i use CDate('') strange topic anyway. – kamahl Sep 06 '11 at 13:13
  • @excelguy: it was merely linking to the top-level Access/Jet SQL in the Access2003 online reference i.e. not particularly useful anyhow so I've removed it. – onedaywhen Mar 29 '18 at 10:23