Use Access Jet Engine to read excel files in C#

In a recent project I used the microsoft jet engine to parse out a Excel spreadsheet in code.  When trying to run this code I  got the error

In order to do this I had to install the 32 bit Access Connectivity Engine from Microsoft.  The key is that you will need the 2010 32 bit install.  The 64 bit will not work.

ACE (Access Connectivity Engine)

Jet Vs Ace