{"id":1195,"date":"2022-06-28T13:51:46","date_gmt":"2022-06-28T11:51:46","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1195"},"modified":"2022-11-03T18:23:56","modified_gmt":"2022-11-03T17:23:56","slug":"exporter-table-sql-server-vers-excel","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/","title":{"rendered":"Exporter une table SQL Server vers Excel avec SSMS"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment exporter une table SQL Server vers Excel avec l&rsquo;assistant Import et Export SSMS ?<\/em><\/strong><\/h4>\n\n\n\n<p>Avec l&rsquo;assistant Import \/ Export de donn\u00e9es SQL Server disponible avec SSMS, il est possible d&rsquo;exporter des donn\u00e9es SQL Server de mani\u00e8re simple. Nous allons voir ensemble comment exporter les donn\u00e9es depuis une table SQL Server, ici la table Clients, vers un fichier Excel, sans \u00e9crire de code SQL.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#1-tutoriel-pour-exporter-une-table-sql-server-dans-un-fichier-excel-avec-ssms\" >1. Tutoriel pour exporter une table SQL Server dans un fichier Excel avec SSMS<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#11-lancer-lassistant-import-et-export-sql-server-depuis-ssms\" >1.1 Lancer l&rsquo;assistant Import et Export SQL Server depuis SSMS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#12-choisir-le-type-de-fichier-microsoft-excel-et-le-chemin-de-sauvegarde\" >1.2 Choisir le type de fichier Microsoft Excel et le chemin de sauvegarde<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#13-depuis-lassistant-ssms-choisir-le-type-de-copie-et-longlet-de-destination\" >1.3 Depuis l&rsquo;assistant SSMS choisir le type de copie et l&rsquo;onglet de destination<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#2-configurer-le-mapping-et-executer-lexport-de-la-table-sql\" >2. Configurer le mapping et ex\u00e9cuter l&rsquo;export de la table SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#3-verifier-les-resultats-et-le-contenu-du-fichier-excel\" >3. V\u00e9rifier les r\u00e9sultats et le contenu du fichier Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-tutoriel-pour-exporter-une-table-sql-server-dans-un-fichier-excel-avec-ssms\"><span class=\"ez-toc-section\" id=\"1-tutoriel-pour-exporter-une-table-sql-server-dans-un-fichier-excel-avec-ssms\"><\/span>1. Tutoriel pour exporter une table SQL Server dans un fichier Excel avec SSMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici un tutoriel SQL Server qui explique pas \u00e0 pas comment exporter les donn\u00e9es d&rsquo;une table SQL Server vers un fichier Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11-lancer-lassistant-import-et-export-sql-server-depuis-ssms\"><\/span>1.1 Lancer l&rsquo;assistant Import et Export SQL Server depuis SSMS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Premi\u00e8rement, dans SQL Server Management Studio, faire un <strong>clic-droit sur la base de donn\u00e9es<\/strong> dans laquelle se trouve le contenu \u00e0 exporter, puis cliquer sur <strong>Task<\/strong>, et ensuite sur <strong>Export Data<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"526\" height=\"477\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg\" alt=\"Ouvrir la t\u00e2che SQL Server Export data depuis SSMS pour exporter une table vers un fichier Excel\" class=\"wp-image-1197\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg 526w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2-300x272.jpg 300w\" sizes=\"auto, (max-width: 526px) 100vw, 526px\" \/><figcaption class=\"wp-element-caption\"><strong>Ouvrir la t\u00e2che SQL Server Export data depuis SSMS<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Ensuite, sous SQL Server Import and Export Wizard, s\u00e9lectionner d\u2019abord la base de donn\u00e9es \u00e0 utiliser pour l\u2019export des donn\u00e9es vers le fichier Excel puis cliquer sur Next. En Anglais, la fen\u00eatre s&rsquo;appelle <em>SQL Server Import and Export Wizard<\/em>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"401\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-3.jpg\" alt=\"\" class=\"wp-image-1198\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-3.jpg 555w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-3-300x217.jpg 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-2-choisir-le-type-de-fichier-microsoft-excel-et-le-chemin-de-sauvegarde\"><span class=\"ez-toc-section\" id=\"12-choisir-le-type-de-fichier-microsoft-excel-et-le-chemin-de-sauvegarde\"><\/span>1.2 Choisir le type de fichier Microsoft Excel et le chemin de sauvegarde<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Choisir le type et donc le format de destination de l&rsquo;export, un choix entre une multitude de destinations est disponible (connexions directes aux bases cibles, fichiers Access, fichiers plats, etc.), dans ce cas c\u2019est dans un fichier Excel, choisir donc le type d&rsquo;export Microsoft Excel.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"401\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-4.jpg\" alt=\"\" class=\"wp-image-1199\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-4.jpg 557w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-4-300x216.jpg 300w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/figure><\/div>\n\n\n<p>Indiquer l\u2019emplacement du fichier sur le poste de travail, pour cela cliquer sur Browse et s\u00e9lectionner le dossier et le nom du fichier Excel exporter les donn\u00e9es contenues dans la table des Clients.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"404\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-5.jpg\" alt=\"Fichier Excel cible pour exporter la table avec SSMS\" class=\"wp-image-1200\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-5.jpg 558w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-5-300x217.jpg 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><figcaption class=\"wp-element-caption\">Fichier Excel cible pour exporter la table avec SSMS<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-3-depuis-l-assistant-ssms-choisir-le-type-de-copie-et-l-onglet-de-destination\"><span class=\"ez-toc-section\" id=\"13-depuis-lassistant-ssms-choisir-le-type-de-copie-et-longlet-de-destination\"><\/span>1.3 Depuis l&rsquo;assistant SSMS choisir le type de copie et l&rsquo;onglet de destination<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Choisir ensuite comment exporter les donn\u00e9es. Il faut donc choisir entre cocher des tables ou utiliser une requ\u00eate SQL. Dans ce cas, nous allons choisir les tables \u00e0 s\u00e9lectionner.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"553\" height=\"401\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-6.jpg\" alt=\"\" class=\"wp-image-1201\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-6.jpg 553w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-6-300x218.jpg 300w\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" \/><\/figure><\/div>\n\n\n<p>Ensuite, cocher les tables \u00e0 exporter et choisir dans quel onglet Excel les exporter. Dans ce cas c&rsquo;est un nouvel onglet, le nom de l&rsquo;onglet Excel est propos\u00e9 automatiquement. L&rsquo;onglet sera cr\u00e9\u00e9 par le package d&rsquo;export.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"402\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-7.jpg\" alt=\"Mapping entre les tables et les fichiers Excel cibles pour l'export avec SSMS\" class=\"wp-image-1202\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-7.jpg 558w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-7-300x216.jpg 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><figcaption class=\"wp-element-caption\">Mapping entre les tables et les fichiers Excel cibles pour l&rsquo;export avec SSMS<\/figcaption><\/figure><\/div>\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/ssms\/telecharger-sql-server-management-studio-18-ssms\/\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-configurer-le-mapping-et-executer-l-export-de-la-table-sql\"><span class=\"ez-toc-section\" id=\"2-configurer-le-mapping-et-executer-lexport-de-la-table-sql\"><\/span>2. Configurer le mapping et ex\u00e9cuter l&rsquo;export de la table SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Les colonnes d\u2019Excel sont par d\u00e9faut de type VarChar. Or, certaines colonnes de la table ne le sont pas, il suffit d\u2019ignorer cette diff\u00e9rence de format. Dans la colonne on Error choisir donc <strong>Ignore<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"567\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-8.jpg\" alt=\"\" class=\"wp-image-1203\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-8.jpg 558w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-8-295x300.jpg 295w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/figure><\/div>\n\n\n<p>Il est possible de sauvegarder le package (SSIS), dans cet exemple, ne pas sauvegarder, cocher ainsi la case <em>Run immediately<\/em> pour proc\u00e9der directement \u00e0 l\u2019export des donn\u00e9es. L&rsquo;option <em>Sauvegarder le package SSIS<\/em> permet de rendre le package disponible et de le r\u00e9utiliser ult\u00e9rieurement.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"405\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-9.jpg\" alt=\"Option SSIS d'ex\u00e9cution pour exporter la table vers Excel\" class=\"wp-image-1204\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-9.jpg 555w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-9-300x219.jpg 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><figcaption class=\"wp-element-caption\">Option SSIS d&rsquo;ex\u00e9cution pour exporter la table vers Excel<\/figcaption><\/figure><\/div>\n\n\n<p>Un r\u00e9capitulatif des param\u00e9trages effectu\u00e9s s&rsquo;affiche dans la fen\u00eatre SSMS. V\u00e9rifier afin de corriger les erreurs \u00e9ventuelles. Puis cliquer sur le bouton <strong>Finish<\/strong> afin de lancer l\u2019export.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"542\" height=\"558\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-10.jpg\" alt=\"R\u00e9capitulatif des options pour exporter les donn\u00e9es de la table vers Excel\" class=\"wp-image-1205\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-10.jpg 542w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-10-291x300.jpg 291w\" sizes=\"auto, (max-width: 542px) 100vw, 542px\" \/><figcaption class=\"wp-element-caption\">R\u00e9capitulatif des options pour exporter les donn\u00e9es de la table vers Excel<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-verifier-les-resultats-et-le-contenu-du-fichier-excel\"><\/span>3. V\u00e9rifier les r\u00e9sultats et le contenu du fichier Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Un \u00e9cran s\u2019affiche avec le d\u00e9tail de toutes les \u00e9tapes du transfert des donn\u00e9es. Signalant \u00e9galement la r\u00e9ussite de l\u2019export \u00e9tape par \u00e9tape, dans ce cas, toutes les \u00e9tapes se sont pass\u00e9es sans probl\u00e8me.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"400\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-11.jpg\" alt=\"Export avec succ\u00e8s de la table des clients dans le fichier Excel depuis SSMS\" class=\"wp-image-1206\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-11.jpg 557w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-11-300x215.jpg 300w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><figcaption class=\"wp-element-caption\">Export avec succ\u00e8s de la table des clients dans le fichier Excel depuis SSMS<\/figcaption><\/figure><\/div>\n\n\n<p>Voil\u00e0, la table SQL est bien export\u00e9e. Pour v\u00e9rifier, ouvrir le fichier Excel et v\u00e9rifier que le contenu est identique. Si l&rsquo;\u00e9cran d&rsquo;ex\u00e9cution remonte un warning ou une erreur alors un mapping s&rsquo;est mal pass\u00e9. Techniquement, c&rsquo;est un package SSIS qui est g\u00e9n\u00e9r\u00e9 par <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/ssms\/download-sql-server-management-studio-ssms?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SSMS<\/a> et ex\u00e9cut\u00e9. Voici la liste compl\u00e8te des <a href=\"https:\/\/expert-only.com\/tutoriels-ssis\/\">tutoriels SSIS<\/a>. Finalement, cette m\u00e9thode simple permet d&rsquo;exporter une table SQL Server vers Excel avec SSMS, de mani\u00e8re efficace et sans aucune ligne de code.<\/p>\n\n\n\n<p>Il est aussi possible de <a href=\"https:\/\/expert-only.com\/ssis\/exporter-table-sql-server-fichier-excel-ssis\/\">d\u00e9velopper un package SSIS pour exporter les donn\u00e9es depuis SQL Server vers Excel<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/ssis\/exporter-table-sql-server-fichier-excel-ssis\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment exporter une table SQL Server vers Excel avec l&rsquo;assistant Import et Export SSMS ? Avec l&rsquo;assistant Import \/ Export de donn\u00e9es SQL Server disponible avec SSMS, il est possible d&rsquo;exporter des donn\u00e9es SQL Server de mani\u00e8re simple. Nous <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\" title=\"Exporter une table SQL Server vers Excel avec SSMS\">&#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":[10],"tags":[19,21,353,37,92,98],"class_list":{"0":"post-1195","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-ssms","7":"tag-assistant-sql-server","8":"tag-astuce","9":"tag-base-de-donnees","10":"tag-clients","11":"tag-excel","12":"tag-export"},"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>Exporter une table SQL Server vers Excel avec SSMS<\/title>\n<meta name=\"description\" content=\"Comment exporter une table SQL Server vers un fichier Excel avec SSMS ? Utiliser l&#039;assistant Import Export de donn\u00e9es de Management Studio.\" \/>\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\/ssms\/exporter-table-sql-server-vers-excel\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporter une table SQL Server vers Excel avec SSMS\" \/>\n<meta property=\"og:description\" content=\"Comment exporter une table SQL Server vers un fichier Excel avec SSMS ? Utiliser l&#039;assistant Import Export de donn\u00e9es de Management Studio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\" \/>\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-06-28T11:51:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-03T17:23:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg\" \/>\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=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Exporter une table SQL Server vers Excel avec SSMS\",\"datePublished\":\"2022-06-28T11:51:46+00:00\",\"dateModified\":\"2022-11-03T17:23:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\"},\"wordCount\":761,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg\",\"keywords\":[\"assistant sql server\",\"astuce\",\"base de donn\u00e9es\",\"clients\",\"excel\",\"export\"],\"articleSection\":[\"SSMS\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\",\"url\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\",\"name\":\"Exporter une table SQL Server vers Excel avec SSMS\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg\",\"datePublished\":\"2022-06-28T11:51:46+00:00\",\"dateModified\":\"2022-11-03T17:23:56+00:00\",\"description\":\"Comment exporter une table SQL Server vers un fichier Excel avec SSMS ? Utiliser l'assistant Import Export de donn\u00e9es de Management Studio.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exporter une table SQL Server vers Excel avec SSMS\"}]},{\"@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":"Exporter une table SQL Server vers Excel avec SSMS","description":"Comment exporter une table SQL Server vers un fichier Excel avec SSMS ? Utiliser l'assistant Import Export de donn\u00e9es de Management Studio.","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\/ssms\/exporter-table-sql-server-vers-excel\/","og_locale":"fr_FR","og_type":"article","og_title":"Exporter une table SQL Server vers Excel avec SSMS","og_description":"Comment exporter une table SQL Server vers un fichier Excel avec SSMS ? Utiliser l'assistant Import Export de donn\u00e9es de Management Studio.","og_url":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-06-28T11:51:46+00:00","article_modified_time":"2022-11-03T17:23:56+00:00","og_image":[{"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg","type":"","width":"","height":""}],"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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Exporter une table SQL Server vers Excel avec SSMS","datePublished":"2022-06-28T11:51:46+00:00","dateModified":"2022-11-03T17:23:56+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/"},"wordCount":761,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg","keywords":["assistant sql server","astuce","base de donn\u00e9es","clients","excel","export"],"articleSection":["SSMS"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/","url":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/","name":"Exporter une table SQL Server vers Excel avec SSMS","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg","datePublished":"2022-06-28T11:51:46+00:00","dateModified":"2022-11-03T17:23:56+00:00","description":"Comment exporter une table SQL Server vers un fichier Excel avec SSMS ? Utiliser l'assistant Import Export de donn\u00e9es de Management Studio.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-2008-export-donnees-assistant-2.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Exporter une table SQL Server vers Excel avec SSMS"}]},{"@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\/1195","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=1195"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1195\/revisions"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}