Export to Excel and Microsoft Jet
-
I am given an ASP.NET project. There is a page with export to excel button. I am shown that the export to excel button works in a machine with office installed and visual studio installed. Now the project is moved to a new server. It has only IIS. The project works, but the export to excel does not work. I look at the connection string and find out it refers to Microsoft Jet. Could it be that I need to install Microsoft Jet to the new server?
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strNewPath & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2"""
-
I am given an ASP.NET project. There is a page with export to excel button. I am shown that the export to excel button works in a machine with office installed and visual studio installed. Now the project is moved to a new server. It has only IIS. The project works, but the export to excel does not work. I look at the connection string and find out it refers to Microsoft Jet. Could it be that I need to install Microsoft Jet to the new server?
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strNewPath & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2"""
Hi, Provider=Microsoft.Jet.OLEDB is a driver and it exists in every machine which has .Net framework installed but in order to export to Excel the machine needs to have Office Excel installed.
-
Hi, Provider=Microsoft.Jet.OLEDB is a driver and it exists in every machine which has .Net framework installed but in order to export to Excel the machine needs to have Office Excel installed.
May I assume that you mean the client machine needs to have Excel installed?
-
May I assume that you mean the client machine needs to have Excel installed?
Absolutely no. The exportation occurs in the app server so I mean your server needs to have Excel installed.