Excel SQL语法JET OleDB参考？ [英] Excel SQL Syntax JET OleDB Reference?

问题描述

Excel文件上的SQL是否有任何资源，覆盖：

格式，数据类型，数据转换，支持的语句...？

谢谢

解决方案

SQL语法与Access数据库引擎（ACE，Jet，无论什么）版本4.0（通过Access2003的Access2000）相同。有关帮助，请参阅 Access2003 SQL参考。

驱动程序/提供者编写数据类型的方式有点奇怪，可能会令人沮丧，您不能仅仅指定应该是什么（就像您可以使用文本文件schema.ini文件）。 我在这个主题上写的这篇文章

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

解决方案

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

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.

这篇关于Excel SQL语法JET OleDB参考？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！