Microsoft.Jet.OLEDB.4.0 - 32bit and 64bit RRS feed

  • Question

  • We are having a 64Bit compatibility problem.  Something that was working in 32 bit is no longer working in 64 bit.  We need a short / Quick solution for the following:

    The issue we are having is with the
    Microsoft.Jet.OLEDB.4.0 driver. We are using this driver to read and write data to the Excel File (Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties="Excel 8.0;IMEX=1;HDR=YES;").


    But currently the Microsoft.Jet.OLEDB.4.0 is not supported for the 64 bit OS. The topic titled Deprecated MDAC/WDAC Components in the below given link describes about this issue. It also suggests using a new driver (2007 Office System Driver) as a replacement to the current JET driver. But when I did a quick search about this new driver, it says the 2007 Office System Driver is also currently supported in 32 bit OS versions (need to confirm on this)

    Saturday, January 2, 2010 5:00 PM


All replies