SQL SERVER 2008 64-bit system cannot import access/excel what to do _mssql2008

Operating system Windows Server 2008 X64, database SQL Server 2008 X64,office 2007 (as if only 32 bits), encountered a problem while the stored procedure was executing opendatasource importing Access data, OLE DB 4.0 is no longer supported, here are some of the error prompts encountered:

Because the OLE DB provider ' Microsoft.Jet.OLEDB.4.0 ' is configured to run in single-threaded apartment mode, the provider cannot be used for distributed queries.
Unable to create an instance of the linked server "(null)" OLE DB provider "microsoft.ace.oledb.12.0".

Because the OLE DB provider ' microsoft.ace.oledb.12.0 ' is configured to run in single-threaded apartment mode, the provider cannot be used for distributed queries.

The solution is to install the Office 2010 64-bit version, there are many downloads on the web, and then download the X64 version of Microsoft Access Database Engine 2010, which is also available online.

Then change the OpenDataSource parameters, the microsoft.jet.oledb.4.0 changed to microsoft.ace.oledb.12.0, finished.

Paste the stored procedure part code:

The above content is only my personal opinion, I believe that the solution is more than mentioned above, I hope that we share their views, and exchange learning progress. I hope this article is helpful for the solution that the SQL SERVER 2008 64-bit system cannot import access/excel.