Thanks for this. Was having issues with running x64 SQL Server and getting the data from the x86 Office apss into it. So, this would solve the issue I'm having with Excel, but any idea what to do with MS Access? Getting this error:
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
May not be the right thread for this, but if someone could point me in the right direction that would be great.