I'm in a bit of a pickle here! I have a document library which contains Excel files on Moss 2007 (64bit). When a file gets upload to the library, a workflow kicks off with some custom activities I've wrote in C#. One of the activities opens the SPFile object (the Excel data) for the SPListItem object thats currently been added. It dumps the stream to a temp file on the hdd (a random .xslx file) and attempts to open it.... but i get this error:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
So i dig about a bit and it turns out there is no 64bit jet drivers for windows 64bit. If i compile my activity to 32bit, it doesnt seem to be able to interface with the 64bit installation of sharepoint!!
What can i do to get round this?!
View Complete Post