請問如何用ADO連結EXCEL檔,並連結成Recordset,
目前只能建立ADO CONNECTION:
dim cn1 as new ADODB.Connection
cn1.Open "Driver={Microsoft Excel Driver (*.xls)};" _
& "DBQ=c:\...\;DriverID=790"
但是Create Recordset確失敗
rsSource.Open "select * from " & gsPath & "\" & gsFileName, cn1, adOpenStatic, adLockReadOnly