Ⅰ）将Excel97或Excel2000生成的XLS文件（book）看成一个数据库，其中的每一个工作表(sheet)看成数据库表

Ⅱ）ADO假设Excel中的第一行为字段名.所以你定义的范围中必须要包括第一行的内容

Ⅲ）Excel中的行标题（即字段名）不能够包含数字. Excel的驱动在遇到这种问题时就会出错的。例如你的行标题名为"F1"

Ⅳ）如果Excel表中某一列同时包含了文本和数字的话,那么Excel的ODBC驱动将不能够正常处理这一行的数据类型，你必须要保证该列的数据类型一致(加入预设符号强制转成文本，后台再作处理)

Ⅴ）日期型时，整列不能有空格，否则读不出- Ⅰ) will Excel97 or Excel2000 generated XLS file (book) as a database, where each worksheet (sheet) as a database table

Ⅱ) ADO assumption Excel field names in the first row, so you define the scope of the contents must include the first row

Ⅲ) Excel in a row heading (ie field names) can not contain numbers. Excel driver in the face of this problem will go wrong. For example, your line entitled "F1"

Ⅳ) If Excel table contains a column of text and numbers, then the Excel ODBC driver will not be able to properly handle this type of data rows, you must ensure that consistent data type of the column (added to the default symbol compulsory transfer into text, the background for further processing)

Ⅴ) Date type, the entire column can not have spaces, otherwise I can not reproduce