<p>Plusieurs méthodes :</p>
<p><strong>1. Convertir en CSV puis importer :</strong></p>
<pre data-code-wrap="sql"><code class="lang-sql">LOAD DATA INFILE '/chemin/fichier.csv'
INTO TABLE ma_table
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
</code></pre>
<p><strong>2. Utiliser MySQL Workbench :</strong><br>
Table > Import Data Wizard</p>
<p><strong>3. Via Python :</strong></p>
<pre data-code-wrap="python"><code class="lang-python">import pandas as pd
import sqlalchemy
df = pd.read_excel('fichier.xlsx')
engine = sqlalchemy.create_engine('mysql://user:pass@localhost/db')
df.to_sql('ma_table', engine, if_exists='replace')
</code></pre>
