odbcjt32 documentation

Question

User1312078811 posted

I work with ASP.NET and I am trying to upload and import excel to SQL. (BTW This is on a new web-server). Our old webserver worked fine... The issue I am running into is, our server admins installed odbcjt32.dll on the new web server. We no longer have Microsoft.Jet.OLEDB.4.0 or Microsoft.ACE.OLEDB.12.0;Data installed. I cannot find any documentation on how to add a connection string in web.config for this odbcjt32.dll, or if it is used in the same way. Everything I can find refers to desktop apps only. Has anyone used this odbcjt32.dll in an ASP.Net web forms app to import excel data into sql? If so, can you post an example to point me in right direction? Is this used with web.config connection strings?

Like this:<add name="Excel07ConString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR={0}'" />

Answer 1

User753101303 posted

Hi,

Seems you are looking for https://www.microsoft.com/en-us/download/details.aspx?id=13255 (make sure to install the version that matches your app ie 64 bit if your app runs as a 64 bit process).

Answer 2

User1312078811 posted

historically we have used a connection string in the web.config for excel based on the version. These are the two that I have been using.

<add name="Excel03ConString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR={0}'" />

<add name="Excel07ConString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR={0}'" />

I cannot find any documentation on 16. is the string the same, should I just replace the 12 with 16?

I am seeing “Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)"  What is the correct syntax for the connection string?

Answer 3

User753101303 posted

Unclear. My understanding is that you are missing Microsoft.ACE.OLEDB.12.0. The earlier link is to install this missing component (or perhaps the very latest at https://www.microsoft.com/en-us/download/details.aspx?id=54920) Make sure that what used to work now works again.

Now it seems you are perhaps trying to add support for xlsx files. According to the "Install" section you should be able to use :

File Type (extension)                                             Extended Properties
---------------------------------------------------------------------------------------------
Excel 97-2003 Workbook (.xls)                                  "Excel 8.0"
Excel 2007-2010 Workbook (.xlsx)                             "Excel 12.0 Xml"
Excel 2007-2010 Macro-enabled workbook (.xlsm)      "Excel 12.0 Macro"
Excel 2007-2010 Non-XML binary workbook (.xlsb)      "Excel 12.0"

If you still need help please be expliciit abour the current situation. It's easier to help if we understand first which problem you are trying to solve.