文件名称:ASP_Read_EXCEL_Data
-
所属分类:
- 标签属性:
- 上传时间:2014-02-10
-
文件大小:9.08kb
-
已下载:0次
-
提 供 者:
-
相关连接:无下载说明:别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容来自于网络,使用问题请自行百度
Ⅰ)将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
Ⅱ)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
(系统自动生成,下载前可以参看下载内容)
下载文件列表
ASP读取EXCEL数据.doc
本网站为编程资源及源代码搜集、介绍的搜索网站,版权归原作者所有! 粤ICP备11031372号
1999-2046 搜珍网 All Rights Reserved.