The Set cn=Server. CreateObject (" ADODB. Connection ")
Cn. The Provider="Microsoft. ACE. The OLEDB. 12.0"
Cn. The ConnectionString="Data Source=" & amp; Server. MapPath ("./offerings/kd_new XLSX ") & amp; "; Extended Properties=12.0 Excel; HDR=Yes; IMEX=1;"
Cn. Open

Copy of the online, after the operation errors, (cn. Open the line error,)
Microsoft Access Database Engine error '80004005'

Could not find the ISAM can be installed,

Line/kd_new_update. Asp, 37
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
In corresponding to the IIS application pool, "set up the application pool default property" right click on the "advanced Settings"/" enable 32-bit applications ", is set to true,

Online said to change the IIS Settings are changed,
What's so wrong, what reason?

CodePudding user response:

Use system control panel - first management tools - data sources (ODBC) to choose the corresponding drivers see would be successful in the connection test, make sure drive no problem first,

CodePudding user response:

Users under the DSN data source only dBASE files (*. DBF) Excel files (*. XLS) MS Access Database (*. MDB) three, right? Need to add anything else?

CodePudding user response:

That is the system didn't drive, download and install the https://www.microsoft.com/en-us/download/details.aspx? Id=13255,

CodePudding user response:

Do not, Q2776478814, can remote processing

CodePudding user response:

This can, you can open the test under http://www.fchee.com/tool/excel/

CodePudding user response:

https://www.microsoft.com/en-US/download/details.aspx? Id=13255

First the driver under the server

StrConn="Provider=Microsoft. ACE. The OLEDB. 12.0. "& amp; _
"Data Source=" & amp; FileName & amp; ";" & _
"Extended Properties=" "Excel 12.0;" & _
"IMEX=1;" & _
"HDR=Yes;" "
"
And in this way

CodePudding user response:

Excell import access to use, there is no problem

Dim connxls, connstrxls
Connstrxls=DBQ="D: \ my documents \ \ temp \ desktop ex \ gaozhong XLS. DefaultDir=; DRIVER={Microsoft Excel DRIVER (*. XLS)};"
The set connxls=server. Createobject (" ADODB. CONNECTION ")
Connxls. Open connstrxls

CodePudding user response:

It is said that above win2012 system version