Reading Excel 2007 Files with 64 Bit Enviornments

There are many issues in reading excel 2007 files using dotnet framework. This might work for 32 bit environment, but doesn't work for 64 bit environment.

If you want this to work you need to compile your project using *86 compilation.
You can do this by right clicking the project and choosing properties. Then a new window will appear with project details. Select the Build tab and from there you need select target CPU dropdown. There you need to select *86 platform.

This will probably be fixed by the dotnet team with a patch hopefully.