Workflow Soluiton

I am following this Connect article for assitance setting up a basic workflow to read in data from an Excel spreadsheet. 

I have added the Office component library and the Read Excel Spreadsheet component to my project. After selecting the Excel file and the sheet in the workbook, I am unable to preview the data or to select OK to exit the component properties sheet. Instead, an error is thrown: The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine.

I am running Workflow 7.1SP2  (7.1.1460.1974) on a Windows 7 x64 bit workstation with Microsoft Office 2007 (32 bit).  I have tried installing both the Microsoft Access Database Engine 2010 Redistributable and the 2007 Office System Driver: Data Connectivity Components to no avail. Has anyone had any luck getting this to work?

Thanks!

It doesn't look like that library is able to run in 64bit mode from a quick google search. To get around it, you can set the "Enable 32-Bit Applications" to True in the properties of your App Pool you have setup for Workflow. I tested on my box and was able to import an excel doc.

FYI: The current plans are to deprecate the Read Excel Spreadsheet component above (won't be removed, just a use at your own risk sort of thing). The Excel generators might help you with your issue, though.