hello all I have a problem I want to call an excel file with the help of aspI'll move this to the serverside forum. Can you be more specific about what you want to do? Do you want to just open the Excel file or do you want to pull information out of it using ASP?I want open the file as well as want to modify that also pull te information and edit the existing one alsodepending on the version of the file you can do it directly with ADO with SQL like statement. you just need to connect with the excel Jet Driver.set objconn=server.createobject("adodb.connection")
connpath="DBQ=" & server.mappath("Census2001.mdb")
objconn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & connpath
I use this connection string but it is not workingthat is because that is setup for access database, except for the DBQ.
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\excel\excel.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;"";"
connpath="DBQ=" & server.mappath("Census2001.mdb")
objconn.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & connpath
I use this connection string but it is not workingthat is because that is setup for access database, except for the DBQ.
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\excel\excel.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes;"";"