Last post Jun 29, 2014 10:11 PM by Terry Guo - MSFT
Jun 27, 2014 09:57 AM|Rahul_agg11|LINK
I am exporting Excel to database. I am getting error: Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
I have tried all three solutions given on link:http://www.aspsnippets.com/Articles/The-OLE-DB-provider-Microsoft.Ace.OLEDB.12.0-for-linked-server-null.aspx
After implementing solution 1 and solution 2, I am getting the same error.
On implementing solution 3 my error changes to : OLE DB provider 'Microsoft.ACE.OLEDB.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
MY OS: Windows 7 (64 Bit)
SQL: SQL Server 2008 R2 (64 Bit)
Jun 29, 2014 10:11 PM|Terry Guo - MSFT|LINK
If your windows is 64 bits, you will need to download and install “Microsoft Access Database Engine 2010 Redistributable”
For 64 bits
Hope it helps.