{"id":23060,"date":"2024-01-08T06:36:00","date_gmt":"2024-01-08T05:36:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=23060"},"modified":"2023-03-06T16:48:35","modified_gmt":"2023-03-06T15:48:35","slug":"exporter-table-sql-server-en-csv-python","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/","title":{"rendered":"Exporter une table SQL Server vers un fichier CSV en Python"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-exemple-de-code-python-pour-extraire-les-donnees-d-une-table-sql-server-dans-un-fichier-csv-en-utilisant-les-modules-pyodbc-et-csv\"><strong><em>Exemple de code Python pour extraire les donn\u00e9es d&rsquo;une table SQL Server dans un fichier CSV, en utilisant les modules pyodbc et csv.<\/em><\/strong><\/h4>\n\n\n\n<p>Dans ce tutoriel, nous allons apprendre comment exporter une table SQL Server vers un fichier CSV en utilisant uniquement des scripts Python. Nous passerons en revue 4 \u00e9tapes principales. La premi\u00e8re consiste \u00e0 cr\u00e9er une table d&rsquo;exemple dans SQL Server. La deuxi\u00e8me est de se connecter \u00e0 l&rsquo;instance SQL. La troisi\u00e8me consiste \u00e0 r\u00e9cup\u00e9rer les donn\u00e9es de la table SQL Server \u00e0 l&rsquo;aide d&rsquo;une requ\u00eate SELECT de base.<\/p>\n\n\n\n<p>Ensuite, nous exporterons le contenu de la table vers un fichier CSV en utilisant la biblioth\u00e8que csv en Python. Enfin, nous regrouperons toutes les \u00e9tapes dans un script unique. \u00c0 la fin de ce tutoriel, vous saurez comment exporter des donn\u00e9es d&rsquo;une base de donn\u00e9es SQL Server vers un fichier CSV en utilisant Python. Mais tout d&rsquo;abord, vous avez besoin d&rsquo;une table SQL d&rsquo;exemple \u00e0 exporter.<\/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\/python\/exporter-table-sql-server-en-csv-python\/#1-creer-une-table-sql-server-dexemple-a-exporter\" >1. Cr\u00e9er une table SQL Server d&rsquo;exemple \u00e0 exporter<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#2-se-connecter-a-la-base-de-donnees-sql-server-avec-pyodbc\" >2. Se connecter \u00e0 la base de donn\u00e9es SQL Server avec pyodbc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#3-recuperer-les-donnees-de-la-table-sql-server\" >3. R\u00e9cup\u00e9rer les donn\u00e9es de la table SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#4-creer-le-fichier-et-exporter-les-donnees-avec-le-module-csv\" >4. Cr\u00e9er le fichier et exporter les donn\u00e9es avec le module csv<\/a><\/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\/python\/exporter-table-sql-server-en-csv-python\/#5-code-complet-pour-exporter-une-table-sql-server-en-csv\" >5. Code complet pour exporter une table SQL Server en CSV<\/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\/python\/exporter-table-sql-server-en-csv-python\/#6-conclusion-sur-lexport-de-donnees-sql-server-en-csv-avec-python\" >6. Conclusion sur l&rsquo;export de donn\u00e9es SQL Server en CSV avec Python<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-creer-une-table-sql-server-dexemple-a-exporter\"><\/span>1. Cr\u00e9er une table SQL Server d&rsquo;exemple \u00e0 exporter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ce code cr\u00e9e une table SQL Server d&rsquo;exemple nomm\u00e9e dbo.employees dans une base de donn\u00e9es et ins\u00e8re quatre lignes d&rsquo;exemple. La table a quatre colonnes : id, nom, d\u00e9partement et salaire. La colonne id est d\u00e9finie comme cl\u00e9 primaire de la table.<\/p>\n\n\n\n<p>Les instructions INSERT INTO ins\u00e8rent quatre lignes de donn\u00e9es dans la table dbo.employees. Chaque ligne a des valeurs pour chacune des colonnes dans l&rsquo;ordre sp\u00e9cifi\u00e9, c&rsquo;est-\u00e0-dire : id, nom, d\u00e9partement et salaire.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE dbo.employees (\n   id INT PRIMARY KEY,\n   name VARCHAR(50),\n   department VARCHAR(50),\n   salary INT\n);\n\nINSERT INTO employees VALUES (1, 'John Smith', 'Sales', 50000);\nINSERT INTO employees VALUES (2, 'Jane Doe', 'Marketing', 60000);\nINSERT INTO employees VALUES (3, 'Bob Johnson', 'IT', 70000);\nINSERT INTO employees VALUES (4, 'Alice Wong', 'HR', 55000);<\/pre>\n\n\n\n<p>Une fois termin\u00e9, il suffit de techniquement effectuer 3 \u00e9tapes suivantes, simples, en utilisant les scripts fournis ci-dessous.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-se-connecter-a-la-base-de-donnees-sql-server-avec-pyodbc\"><\/span>2. Se connecter \u00e0 la base de donn\u00e9es SQL Server avec pyodbc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, techniquement les \u00e9tapes sont tr\u00e8s similaires \u00e0 l&rsquo;exportation Excel en utilisant Python, mais bien s\u00fbr le module d&rsquo;exportation utilis\u00e9 dans l&rsquo;\u00e9tape suivante est diff\u00e9rent dans ce cas. La premi\u00e8re \u00e9tape consiste \u00e0 se connecter \u00e0 la base de donn\u00e9es SQL Server en utilisant le module pyodbc.<\/p>\n\n\n\n<p>Dans mon cas, j&rsquo;utilise SQL Server 2019 install\u00e9 sur une machine Windows 10. Et j&rsquo;utilise Visual Studio 2019 pour d\u00e9velopper mes scripts Python. Voici un exemple de code qui \u00e9tablit une connexion \u00e0 une base de donn\u00e9es SQL Server. J&rsquo;utilise une authentification Windows donc je n&rsquo;entre pas de nom d&rsquo;utilisateur et de mot de passe.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># importer le module pyodbc pour g\u00e9rer la connexion ODBC\nimport pyodbc\n\n# d\u00e9clarer des variables pour stocker les d\u00e9tails de connexion\ndriver = 'SQL Server'\nserver = 'localhost'\ndatabase = 'Expert-Only'\n\n# se connecter \u00e0 la base de donn\u00e9es SQL Server\nconnection = pyodbc.connect(f'DRIVER={driver};'\n                            f'SERVER={server};'\n                            f'DATABASE={database};'\n                            f'Trusted_Connection=yes;')<\/pre>\n\n\n\n<p>Assurez-vous de remplacer les espaces r\u00e9serv\u00e9s par les valeurs r\u00e9elles de votre cha\u00eene de connexion SQL Server : driver, server, database, et si n\u00e9cessaire, nom d&rsquo;utilisateur et mot de passe. Dans ce cas, le code serait plut\u00f4t comme ceci :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pyodbc\n\n# se connecter \u00e0 la base de donn\u00e9es SQL Server\nserver = 'localhost'\ndatabase = 'database_name'\nusername = 'username'\npassword = 'password'\ncnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};'\n                      f'SERVER={server};'\n                      f'DATABASE={database};'\n                      f'UID={username};'\n                      f'PWD={password}')\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-recuperer-les-donnees-de-la-table-sql-server\"><\/span>3. R\u00e9cup\u00e9rer les donn\u00e9es de la table SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Une fois que la connexion \u00e0 la base de donn\u00e9es SQL Server est \u00e9tablie, nous pouvons r\u00e9cup\u00e9rer les donn\u00e9es de la table en utilisant une requ\u00eate T-SQL. Voici un exemple de code qui r\u00e9cup\u00e8re toutes les lignes de la table dbo.employees que nous avons cr\u00e9\u00e9e \u00e0 l&rsquo;\u00e9tape 1. Assurez-vous de remplacer \u00ab\u00a0employees\u00a0\u00bb par le nom r\u00e9el de votre table SQL Server.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># retrieve the data from the employees table\ncursor = connection.cursor()\ncursor.execute('SELECT * FROM dbo.employees')\ndata = cursor.fetchall()<\/pre>\n\n\n\n<p>Cet autre tutoriel permet de manipuler des objets SQL Server et des donn\u00e9es au sens large depuis des scrips \u00e9crits en Python. <\/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\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"JoDPkxddkM\"><a href=\"https:\/\/expert-only.com\/fr\/python\/se-connecter-a-sql-server-avec-python\/\">Comment g\u00e9rer des tables SQL Server avec Python ?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Comment g\u00e9rer des tables SQL Server avec Python ?\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/python\/se-connecter-a-sql-server-avec-python\/embed\/#?secret=QFf8uJEDs1#?secret=JoDPkxddkM\" data-secret=\"JoDPkxddkM\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-creer-le-fichier-et-exporter-les-donnees-avec-le-module-csv\"><\/span>4. Cr\u00e9er le fichier et exporter les donn\u00e9es avec le module csv<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enfin, nous pouvons cr\u00e9er un fichier CSV en utilisant le module csv et \u00e9crire les donn\u00e9es dans ce fichier. Voici un exemple de code qui cr\u00e9e un nouveau fichier CSV nomm\u00e9 employees.csv et \u00e9crit les donn\u00e9es r\u00e9cup\u00e9r\u00e9es dedans. Encore une fois, assurez-vous de remplacer le chemin et le nom de fichier par le nom r\u00e9el que vous voulez donner \u00e0 votre fichier CSV.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># importer le module Python csv\nimport csv\n\n# cr\u00e9er un nouveau fichier CSV et \u00e9crire les donn\u00e9es dans celui-ci\nwith open(\"C:\\data\\employees.csv\", mode='w', newline='') as file:\n    writer = csv.writer(file)\n    writer.writerows(data)<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-code-complet-pour-exporter-une-table-sql-server-en-csv\"><\/span>5. Code complet pour exporter une table SQL Server en CSV<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;exemple de code Python complet ci-dessous fusionne toutes les \u00e9tapes en un seul script. C&rsquo;est-\u00e0-dire comment exporter les donn\u00e9es SQL Server vers un fichier CSV en utilisant Python. Le script importe les biblioth\u00e8ques n\u00e9cessaires, pyodbc et csv, et \u00e9tablit une connexion \u00e0 la base de donn\u00e9es. Ensuite, il ex\u00e9cute une requ\u00eate SQL pour s\u00e9lectionner les donn\u00e9es. Enfin, il \u00e9crit les donn\u00e9es dans un nouveau fichier CSV en utilisant la biblioth\u00e8que csv.<\/p>\n\n\n\n<p>Les en-t\u00eates sont extraits de la description du <a href=\"https:\/\/tech-lib.fr\/curseur\/\" target=\"_blank\" rel=\"noreferrer noopener\">curseur<\/a> et \u00e9crits dans le fichier en premier, suivis des donn\u00e9es elles-m\u00eames. Une fois l&rsquo;exportation termin\u00e9e, le curseur et la connexion \u00e0 la base de donn\u00e9es sont ferm\u00e9s. Ce code peut \u00eatre facilement modifi\u00e9 pour r\u00e9pondre \u00e0 votre cas d&rsquo;utilisation sp\u00e9cifique en ajustant la cha\u00eene de connexion, le nom de la table et le nom du fichier.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"python\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">import pyodbc\nimport csv\n\n# \u00c9tape 1 : Se connecter \u00e0 l'instance SQL Server\n\n# d\u00e9clarer des variables pour stocker les d\u00e9tails de connexion\ndriver = 'SQL Server'\nserver = 'localhost'\ndatabase = 'Expert-Only'\n\n# se connecter \u00e0 la base de donn\u00e9es SQL Server\nconnection = pyodbc.connect(f'DRIVER={driver};'\n                            f'SERVER={server};'\n                            f'DATABASE={database};'\n                            f'Trusted_Connection=yes;')\n\n# \u00c9tape 2 : R\u00e9cup\u00e9rer les donn\u00e9es de la table SQL Server\n\ncursor = connection.cursor()\ncursor.execute('SELECT * FROM dbo.employees')\ndata = cursor.fetchall()\n\n# \u00c9tape 3 : \u00c9crire les donn\u00e9es dans le fichier CSV\nwith open(\"C:\\data\\employees.csv\", mode='w', newline='') as file:\n    writer = csv.writer(file)\n    writer.writerow([x[0] for x in cursor.description])  # write header\n    for row in data:\n        writer.writerow(row)\n\n# \u00c9tape 4 : Fermer la connexion \u00e0 la base de donn\u00e9es\ncursor.close()\nconnection.close()<\/pre>\n\n\n\n<p>Le r\u00e9sultat est un fichier CSV export\u00e9 directement dans le dossier C:\\data, avec le m\u00eame contenu que la table MS SQL d&rsquo;origine.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"640\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/03\/python-export-sql-server-table-to-csv-file.jpg\" alt=\"Comment exporter une table SQL Server dans un fichier CSV en Python ? Fichier export\u00e9 sous Windows.\" class=\"wp-image-22986\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/03\/python-export-sql-server-table-to-csv-file.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/03\/python-export-sql-server-table-to-csv-file-300x267.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\"><strong><em>Comment exporter une table SQL Server dans un fichier CSV en Python ? Fichier export\u00e9 sous Windows.<\/em><\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Bien s\u00fbr, vous devez \u00e9galement remplacer et d\u00e9finir ces 3 variables avec vos propres valeurs :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>driver<\/li>\n\n\n\n<li>server<\/li>\n\n\n\n<li>database<\/li>\n<\/ul>\n\n\n\n<p>Et si vous n&rsquo;utilisez pas un compte Windows pour ex\u00e9cuter le script Python :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>nom d&rsquo;utilisateur<\/li>\n\n\n\n<li>mot de passe<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-conclusion-sur-lexport-de-donnees-sql-server-en-csv-avec-python\"><\/span>6. Conclusion sur l&rsquo;export de donn\u00e9es SQL Server en CSV avec Python<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En conclusion, apr\u00e8s avoir suivi toutes les \u00e9tapes d\u00e9crites dans ce tutoriel Python, vous devriez maintenant \u00eatre en mesure d&rsquo;exporter une table SQL Server vers un fichier CSV. N&rsquo;oubliez pas de vous connecter d&rsquo;abord \u00e0 votre base de donn\u00e9es SQL Server en utilisant pyodbc, puis de r\u00e9cup\u00e9rer les donn\u00e9es de la table et enfin d&rsquo;\u00e9crire les donn\u00e9es dans un fichier CSV en utilisant le module csv.<\/p>\n\n\n\n<p>L&rsquo;exportation de donn\u00e9es vers des fichiers plats est fr\u00e9quente et peut donc \u00eatre une comp\u00e9tence utile pour de nombreuses t\u00e2ches d&rsquo;analyse et de reporting de donn\u00e9es. En automatisant ce processus avec Python, vous pouvez gagner beaucoup de temps et d&rsquo;efforts par rapport \u00e0 un <a href=\"https:\/\/expert-only.com\/fr\/ssms\/exporter-table-sql-server-vers-excel\/\">export manuel depuis SSMS vers Excel<\/a> ou d&rsquo;autres formats de fichiers plats.<\/p>\n\n\n\n<p>En effet, Python fournit un ensemble puissant d&rsquo;outils pour travailler avec des bases de donn\u00e9es et des fichiers de donn\u00e9es. Avec ces outils, vous pouvez grandement am\u00e9liorer votre productivit\u00e9 en tant qu&rsquo;analyste, data scientists ou expert de la donn\u00e9es. Il est important de se familiariser avec les syntaxes basiques de Python et d&rsquo;apprendre \u00e0 manipuler les variables et les chaines de caract\u00e8res par exemple.<\/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\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"P1FkGzSfIv\"><a href=\"https:\/\/expert-only.com\/fr\/python\/syntaxe-de-base-du-langage-python\/\">Syntaxe de base du langage Python avec des exemples<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Syntaxe de base du langage Python avec des exemples\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/python\/syntaxe-de-base-du-langage-python\/embed\/#?secret=bNPUaFb588#?secret=P1FkGzSfIv\" data-secret=\"P1FkGzSfIv\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Exemple de code Python pour extraire les donn\u00e9es d&rsquo;une table SQL Server dans un fichier CSV, en utilisant les modules pyodbc et csv. Dans ce tutoriel, nous allons apprendre comment exporter une table SQL Server vers un fichier CSV <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/\" title=\"Exporter une table SQL Server vers un fichier CSV en Python\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10862,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[656],"tags":[],"class_list":{"0":"post-23060","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-python"},"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 un fichier CSV en Python<\/title>\n<meta name=\"description\" content=\"Tutoriel, pour exporter une table SQL Server vers un fichier CSV en utilisant uniquement des scripts Python et les modules pyodbc et csv.\" \/>\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\/python\/exporter-table-sql-server-en-csv-python\/\" \/>\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 un fichier CSV en Python\" \/>\n<meta property=\"og:description\" content=\"Tutoriel, pour exporter une table SQL Server vers un fichier CSV en utilisant uniquement des scripts Python et les modules pyodbc et csv.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/\" \/>\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=\"2024-01-08T05:36:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Exporter une table SQL Server vers un fichier CSV en Python\",\"datePublished\":\"2024-01-08T05:36:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/\"},\"wordCount\":1136,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"articleSection\":[\"Python\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/\",\"url\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/\",\"name\":\"Exporter une table SQL Server vers un fichier CSV en Python\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"datePublished\":\"2024-01-08T05:36:00+00:00\",\"description\":\"Tutoriel, pour exporter une table SQL Server vers un fichier CSV en utilisant uniquement des scripts Python et les modules pyodbc et csv.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#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 un fichier CSV en Python\"}]},{\"@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 un fichier CSV en Python","description":"Tutoriel, pour exporter une table SQL Server vers un fichier CSV en utilisant uniquement des scripts Python et les modules pyodbc et csv.","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\/python\/exporter-table-sql-server-en-csv-python\/","og_locale":"fr_FR","og_type":"article","og_title":"Exporter une table SQL Server vers un fichier CSV en Python","og_description":"Tutoriel, pour exporter une table SQL Server vers un fichier CSV en utilisant uniquement des scripts Python et les modules pyodbc et csv.","og_url":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-01-08T05:36:00+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","type":"image\/jpeg"}],"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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Exporter une table SQL Server vers un fichier CSV en Python","datePublished":"2024-01-08T05:36:00+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/"},"wordCount":1136,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","articleSection":["Python"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/","url":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/","name":"Exporter une table SQL Server vers un fichier CSV en Python","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","datePublished":"2024-01-08T05:36:00+00:00","description":"Tutoriel, pour exporter une table SQL Server vers un fichier CSV en utilisant uniquement des scripts Python et les modules pyodbc et csv.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/python\/exporter-table-sql-server-en-csv-python\/#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 un fichier CSV en Python"}]},{"@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\/23060","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=23060"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/23060\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10862"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=23060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=23060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=23060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}