我想用vb去讀取Excel表的第二個sheet里面的資料，因為第二個sheet的名字不是固定的，所以需要根據他的位置去讀。我用過一下幾種方法，都失敗了，請高手幫幫我。
SQL = "SELECT * FROM [Sheets(2)]"
SQL = "SELECT * FROM Sheets[2]"
SQL = "SELECT * FROM [Sheets2]"
SQL = "SELECT * FROM (Sheets2)"
SQL = "SELECT * FROM [Sheet(2)]"
SQL = "SELECT * FROM Sheet[2]"
SQL = "SELECT * FROM [Sheet2]"
SQL = "SELECT * FROM (Sheet2)"
SQL = "SELECT * FROM [workSheet(2)]"
SQL = "SELECT * FROM workSheet[2]"
SQL = "SELECT * FROM [workSheet2]"
SQL = "SELECT * FROM (workSheet2)"
SQL = "SELECT * FROM [workSheets(2)]"
SQL = "SELECT * FROM workSheets[2]"
SQL = "SELECT * FROM [workSheets2]"
SQL = "SELECT * FROM (workSheets2)"
uj5u.com熱心網友回復：
Set conn2 = CreateObject("ADODB.Connection")conn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties='Excel 8.0;HDR=Yes;IMEX=1';Data Source=d:\" & t1
這是我連接excel的句子
uj5u.com熱心網友回復：
SQL 陳述句是根據表名訪問的。你必須首先獲得表名。uj5u.com熱心網友回復：
表名都不固定話就比較麻煩了.直接用excel物件還比較好轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/95274.html