OpenSchema ActiveXObject

<mce:script language="javascript" type="text/javascript"><!-- var exlTxt = ""; function importXLS(fileName) { objCon = new ActiveXObject("ADODB.Connection"); objCon.Provider = "Microsoft.Jet.OLEDB.4.0"; objCon.ConnectionString = "Data Source=" + fileName + ";Extended Properties=Excel 8.0;"; objCon.CursorLocation = 1; objCon.Open; var strQuery; //Get the SheetName var strSheetName = "Sheet1?$"; var rsTemp = new ActiveXObject("ADODB.Recordset"); rsTemp = objCon.OpenSchema(20); if (!rsTemp.EOF) strSheetName = rsTemp.Fields("Table_Name").Value; rsTemp = null rsExcel = new ActiveXObject("ADODB.Recordset"); strQuery = "SELECT * FROM [" + strSheetName + "]"; rsExcel.ActiveConnection = objCon; rsExcel.Open(strQuery); j = 0; while (!rsExcel.EOF) { for (i = 0; i < rsExcel.Fields.Count; ++i) { document.write("第"+j+"行第"+i+"列："+rsExcel.Fields(i).value + "<br/>"); } rsExcel.MoveNext; j++; } // Close the connection and dispose the file objCon.Close; objCon = null; rsExcel = null; } // --></mce:script>

OpenSchema是Connection物件所提供的Method
作用是取得資料庫整體結構資訊
語法如下
recordset = connection.OpenSchema ( QueryType, Criteria, SchemaID )

QueryType 20 代表 adSchemaTables
其對應之Criteria有下列4個參數
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE

array(empty,empty,empty,"TABLE") 就是在設定這4個參數
前面3個empty應該不用說明了
後面的"Table"表示只要捉Table_Type為"Table"的資料
也就是只捉資料表資訊
該參數也可改成"VIEW"來捉取所有的VIEW資訊

至於其它用法請參閱MSDN說明
或到以下網址也有說明
http://www.coolasp.com/asp_learn/appendixa/a4-1.cfm.htm