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

2 Responses to “Error Fix: Msg 7403 The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.”

  1. Lucaseto Says:

    In x64 is better install de the conectivity component of office 2010http://letrasandnumeros.com/2010/03/27/cargar-un-archivo-de-excel-en-sql-server-2008-x64/

  2. Lucaseto Says:

    In x64 is better install de the conectivity component of office 2010http://letrasandnumeros.com/2010/03/27/cargar-un-archivo-de-excel-en-sql-server-2008-x64/


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: