{"id":7253,"date":"2019-01-06T08:43:22","date_gmt":"2019-01-06T08:43:22","guid":{"rendered":"https:\/\/dbtut.com\/?p=7253"},"modified":"2019-01-06T08:43:22","modified_gmt":"2019-01-06T08:43:22","slug":"the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/","title":{"rendered":"The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine"},"content":{"rendered":"

 <\/p>\n

ERROR:<\/h3>\n

The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)<\/p>\n

EXPLANATION:<\/h3>\n

I received an error message when I wanted to import a Microsoft Excel file with the extension * .xlsx to SQL Server 2014.<\/p>\n

Excel 2007 was already in the Excel Version list, but obviously something was missing.<\/p>\n

SOLUTION:<\/h3>\n

So I found the solution in a forum, but I wanted to record it here, especially in order to be more compact. If you download and install the following file on SQL Server Server, your problem is resolved without ever restarting the server or SQL Server Management Studio.<\/p>\n

2007 Office System Driver: Data Connectivity Components<\/a><\/p>\n

Depending on the version of excel or the operating system that you use, the Acces Database Engine may change. You should download the appropriate link from the site.<\/p>\n

You can download and install Microsoft Access Database Engine 2010 from the link below.<\/p>\n

Microsoft Access Database Engine 2010 Redistributable<\/a><\/p>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

  ERROR: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) EXPLANATION: I received an error message when I wanted to import a Microsoft Excel file with the extension * .xlsx to SQL Server 2014. Excel 2007 was already in the Excel Version list, but obviously something was missing. SOLUTION: So I found …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":423,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7253","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":425,"today_views":0},"yoast_head":"\nThe 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - Database Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"  ERROR: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) EXPLANATION: I received an error message when I wanted to import a Microsoft Excel file with the extension * .xlsx to SQL Server 2014. Excel 2007 was already in the Excel Version list, but obviously something was missing. SOLUTION: So I found …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-06T08:43:22+00:00\" \/>\n<meta name=\"author\" content=\"Ekrem \u00d6nsoy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ekrem \u00d6nsoy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/\"},\"author\":{\"name\":\"Ekrem \u00d6nsoy\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\"},\"headline\":\"The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine\",\"datePublished\":\"2019-01-06T08:43:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/\"},\"wordCount\":169,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/\",\"name\":\"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"datePublished\":\"2019-01-06T08:43:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46\",\"name\":\"Ekrem \u00d6nsoy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g\",\"caption\":\"Ekrem \u00d6nsoy\"},\"description\":\"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.\",\"url\":\"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - Database Tutorials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/","og_locale":"en_US","og_type":"article","og_title":"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - Database Tutorials","og_description":"  ERROR: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) EXPLANATION: I received an error message when I wanted to import a Microsoft Excel file with the extension * .xlsx to SQL Server 2014. Excel 2007 was already in the Excel Version list, but obviously something was missing. SOLUTION: So I found …","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-06T08:43:22+00:00","author":"Ekrem \u00d6nsoy","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ekrem \u00d6nsoy","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/"},"author":{"name":"Ekrem \u00d6nsoy","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46"},"headline":"The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine","datePublished":"2019-01-06T08:43:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/"},"wordCount":169,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/","name":"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"datePublished":"2019-01-06T08:43:22+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/06\/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/42a3e874ed0bf8053fa123a3a1f6ee46","name":"Ekrem \u00d6nsoy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/478b3dc5048390d7312367b30eee5be99c346dbd83706e82e0dd4e9678b77c94?s=96&d=mm&r=g","caption":"Ekrem \u00d6nsoy"},"description":"The original article was written in Turkish by Ekrem \u00d6nsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.","url":"https:\/\/dbtut.com\/index.php\/author\/ekremonsoy\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/423"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=7253"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7253\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=7253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=7253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=7253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}