[求救]連接excel出錯([Microsoft][ODBC Driver Manager]Driver's SqlSetConnectAttr failed)
各位大蝦,為什麼我在用以下字符串連接excel時發生了這個錯誤:
連庫字串:
Set connE = Server.CreateObject("ADODB.Connection")
connE.Open "Driver={Microsoft Excel Driver (*.xls)};Dbq="& tmp_path
錯誤字串:
[Microsoft][ODBC Driver Manager]Driver's SqlSetConnectAttr failed
connE.Errors(0).SQLState:IM006
注(我在用以下字符串可以連庫成功)
dsn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& tmp_path &";Extended Properties=""Excel 8.0;HDR=No"""