Description: Ⅰ) 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
To Search:
File list (Check if you may need any files):
ASP读取EXCEL数据.doc
Download