Error Fix: Msg 7403 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

One of the reader was trying create excel linked server and was facing below given error.

Msg 7403, Level 16, State 1, Procedure sp_tables_ex, Line 41
The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered.

This is because you don’t have ACE oledb provider installed on your server, you can fix it by downloading and installing driver from Microsoft site.

Download: http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

BTW, you can have a look of my articles for creating linked server of ACCESS and EXCEL at

http://www.sqlhub.com/2009/04/create-linked-server-with-excel-2007.html

http://www.sqlhub.com/2009/03/linked-server-in-sql-server-2005-from.html

Reference: Ritesh Shah

http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com

Advertisements