{"id":1057,"date":"2022-04-28T06:45:00","date_gmt":"2022-04-28T04:45:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1057"},"modified":"2022-05-20T11:07:54","modified_gmt":"2022-05-20T09:07:54","slug":"driver-oledb-excel-2010","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/","title":{"rendered":"Driver OLEDB pour Excel 2010"},"content":{"rendered":"\n<p><strong>T\u00e9l\u00e9charger le driver OLEDB pour Excel 2010 pour installer les pilotes et composants Excel 2010. Cet ensemble de composants est appel\u00e9 Drivers Database Access 2010 ou encore Moteur de base de donn\u00e9es Microsoft Access 2010 redistribuable. Il facilite le transfert et les connexions entre les fichiers Microsoft Office Access 2010 et les fichiers Microsoft Office Excel 2010 vers les bases de donn\u00e9es comme SQL Server (2005, 2008, 2008 R2 et 2012). <\/strong><\/p>\n\n\n\n<p>En effet, le pilote Access 2010 permet par exemple de charger un fichier Excel 2010 vers une base de donn\u00e9es SQL Server 2012. A l&rsquo;aide de SSIS, dans le cadre d&rsquo;un projet Microsoft Business Intelligence par exemple.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-telecharger-les-driver-et-composant-excel-oledb-accessdatabaseengine-exe-pour-excel-2010\">T\u00e9l\u00e9charger les driver et composant Excel OLEDB AccessDatabaseEngine.exe pour Excel 2010<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-telecharger-les-pilotes-odbc-et-oledb-et-les-composants-pour-office-2010\">1. T\u00e9l\u00e9charger les pilotes ODBC et OLEDB et les composants&nbsp;pour Office 2010<\/h3>\n\n\n\n<p>Le fichier d&rsquo;installation du <strong>Driver Office Excel 2010<\/strong> complet est disponible ci-dessous. Le fichier ZIP contient le fichier <strong>AccessDatabaseEngine.exe<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-file aligncenter\"><a id=\"wp-block-file--media-3b0e0b1e-67e5-4de4-86d5-e76ee49531d9\" href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/AccessDatabaseEngine-2010.zip\"><mark style=\"background-color:#fcb900\" class=\"has-inline-color\"><strong>T\u00e9l\u00e9charger le driver Excel 2010 AccessDatabaseEngine.zip<\/strong><\/mark><\/a><a href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/AccessDatabaseEngine-2010.zip\" class=\"wp-block-file__button\" download aria-describedby=\"wp-block-file--media-3b0e0b1e-67e5-4de4-86d5-e76ee49531d9\">T\u00e9l\u00e9charger<\/a><\/div>\n\n\n\n<p>Le fichier provient du site officiel de Microsoft : <a href=\"https:\/\/www.microsoft.com\/fr-fr\/download\/details.aspx?id=13255\" target=\"_blank\" rel=\"noopener noreferrer\">Moteur de base de donn\u00e9es Microsoft Access 2010 redistribuable<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-installer-les-pilotes-odbc-et-oledb-et-les-composants-pour-office-2010\">2. Installer les pilotes ODBC et OLEDB et les composants&nbsp;pour Office 2010<\/h3>\n\n\n\n<p>Deuxi\u00e8mement, installer les pilotes sur la machine Windows.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Double-cliquer sur le fichier <strong>AccessDatabaseEngine.exe<\/strong> pour l&rsquo;installer sur le serveur cible.<\/li><li>Suivre les instructions \u00e0 l&rsquo;\u00e9cran jusqu&rsquo;\u00e0 la fin de l&rsquo;installation.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-utiliser-les-composants-access-database-engine-2010\">3. Utiliser les composants Access Database Engine 2010<\/h3>\n\n\n\n<p>Finalement, faire appel aux pilotes en cr\u00e9ant des connexions Excel utilisant les pilotes.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Si vous utiliser des applications qui utilisent OLEDB<\/strong>, il faut pr\u00e9ciser l&rsquo;argument \u00ab Microsoft.ACE.OLEDB.12.0 \u00bb dans la propri\u00e9t\u00e9 <strong><em>ConnectionString<\/em><\/strong>.<\/li><li><strong>Pour se connecter \u00e0 des bases de donn\u00e9es de types Microsoft Office Excel<\/strong>, ajouter \u00ab Excel 14.0 \u00bb dans les propri\u00e9t\u00e9s de la cha\u00eene de connexion (<strong><em>ConnectionString<\/em> <\/strong>\u00e9galement).<\/li><li><strong>Pour les connections ODBC<\/strong>, il est possible de se connecter \u00e0 des fichiers Excel : XLS, XLSX, XLSM, XLSB. Il faut pr\u00e9ciser les \u00e9l\u00e9ments : DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)} ainsi que l&rsquo;\u00e9l\u00e9ment DBQ=\u00a0\u00bbD:\\Dossier\\Ficher_Excel.xlsx\u00a0\u00bb qui est l&#8217;emplacement du fichier par exemple.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Syst\u00e8mes Windows compatible avec le driver Excel 2010<\/h4>\n\n\n\n<p>Enfin, les syst\u00e8mes d&rsquo;exploitation pris en charge par les drivers et composants Microsoft Office Database Access 2010 sont les suivants.<\/p>\n\n\n\n<p>Pour les versions clients, le driver est compatible avec <strong>Windows 10<\/strong>, Windows 8, Windows 7 (Seven), Windows XP Service Pack 3 et enfin Windows Vista Service Pack 1.<\/p>\n\n\n\n<p>C\u00f4t\u00e9 serveurs, le pilote est compatible avec ces versions : <strong>Windows Server 2012 R2<\/strong>, Windows Server 2008 version R2, Windows Server 2003 R2 (en version 32 bits et 64 bits).<\/p>\n\n\n\n<p>Pour conclure, cet article permet de t\u00e9l\u00e9charger <strong>les pilotes Excel access database engine 2010<\/strong> et explique leur fonctionnement.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-blog-sql-server-et-microsoft-it wp-block-embed-blog-sql-server-et-microsoft-it\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/astuces-excel\/driver-access-database-engine-2016-excel\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>T\u00e9l\u00e9charger le driver OLEDB pour Excel 2010 pour installer les pilotes et composants Excel 2010. Cet ensemble de composants est appel\u00e9 Drivers Database Access 2010 ou encore Moteur de base de donn\u00e9es Microsoft Access 2010 redistribuable. Il facilite le <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/\" title=\"Driver OLEDB pour Excel 2010\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":{"0":"post-1057","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Driver OLEDB pour Excel 2010 - Astuces Excel<\/title>\n<meta name=\"description\" content=\"T\u00e9l\u00e9charger le driver OLEDB pour Excel 2010 pour se connecter \u00e0 des fichiers Excel depuis SQL Server ou Integration Services par exemple.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Driver OLEDB pour Excel 2010\" \/>\n<meta property=\"og:description\" content=\"T\u00e9l\u00e9charger le driver OLEDB pour Excel 2010 pour se connecter \u00e0 des fichiers Excel depuis SQL Server ou Integration Services par exemple.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-28T04:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-20T09:07:54+00:00\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Driver OLEDB pour Excel 2010\",\"datePublished\":\"2022-04-28T04:45:00+00:00\",\"dateModified\":\"2022-05-20T09:07:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/\"},\"wordCount\":449,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"articleSection\":[\"Astuces Excel\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/\",\"url\":\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/\",\"name\":\"Driver OLEDB pour Excel 2010 - Astuces Excel\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"datePublished\":\"2022-04-28T04:45:00+00:00\",\"dateModified\":\"2022-05-20T09:07:54+00:00\",\"description\":\"T\u00e9l\u00e9charger le driver OLEDB pour Excel 2010 pour se connecter \u00e0 des fichiers Excel depuis SQL Server ou Integration Services par exemple.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Driver OLEDB pour Excel 2010\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Driver OLEDB pour Excel 2010 - Astuces Excel","description":"T\u00e9l\u00e9charger le driver OLEDB pour Excel 2010 pour se connecter \u00e0 des fichiers Excel depuis SQL Server ou Integration Services par exemple.","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:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/","og_locale":"fr_FR","og_type":"article","og_title":"Driver OLEDB pour Excel 2010","og_description":"T\u00e9l\u00e9charger le driver OLEDB pour Excel 2010 pour se connecter \u00e0 des fichiers Excel depuis SQL Server ou Integration Services par exemple.","og_url":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-04-28T04:45:00+00:00","article_modified_time":"2022-05-20T09:07:54+00:00","author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Driver OLEDB pour Excel 2010","datePublished":"2022-04-28T04:45:00+00:00","dateModified":"2022-05-20T09:07:54+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/"},"wordCount":449,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"articleSection":["Astuces Excel"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/","url":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/","name":"Driver OLEDB pour Excel 2010 - Astuces Excel","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"datePublished":"2022-04-28T04:45:00+00:00","dateModified":"2022-05-20T09:07:54+00:00","description":"T\u00e9l\u00e9charger le driver OLEDB pour Excel 2010 pour se connecter \u00e0 des fichiers Excel depuis SQL Server ou Integration Services par exemple.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/excel\/driver-oledb-excel-2010\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Driver OLEDB pour Excel 2010"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1057","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1057"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1057\/revisions"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1057"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}