Using LinqToExcel on a 64-bit build

The p开发者_开发知识库age for LinqToExcel says it is required to compile the solution against x86.

How about, as I am using 64-bit Oracle, my application needs to be a 64-bit one.

Is there anything I can do?

I am not sure you do need it to be 64 bit as Oded says. I think the problem with LinqToExcel might be related to the fact that there is no compatible 64bit OLEDB Jet driver. MS did finally produce one for Office 2010 but it is likely you won't be able to just install it and get LinqToExcel to work. Please note whilst is is called the Access Data Engine, it is used for programatic access to excel spreadsheets as well.

Create A 64 Bit Service with wcf to handle the 64bit Oracle Calls. Create a 32 bit program to handle the linq2Excel that then calls the WCF service to handle your data saves.