none
How to read an excel file from a 64 bit .Net application if 32 bit MS Office is installed in a 64 bit OS?

    Question

  • Our configuration:

    Our Application: 64 bit .Net application.

    MS Office installed : 32 bit.

    OS: Win 7 64 bit.

    Connection string used:  con = new OleDbConnection(@"Provider=Microsoft.ace.OLEDB.12.0;Data Source=" + filename + ";Extended Properties=Excel 8.0");

    Problem:

    This works perfectly fine if we have 64 bit MS Office installed in a 64 bit OS. But, it doesn't work if 32 bit MS office is installed. When we tried installing "AccessDatabaseEngine_x64.exe", we got a message saying that we need to uninstall 32 bit MS office components first, which we can't do.

    Could you please suggest any resolution?

    Saturday, August 03, 2013 7:14 AM

Answers

All replies