insert every row of an Excel spreadsheet into a database in MYSQL

Question

I know this can be done with any programmatic language like Python that interacts with both databases and Excel spreadsheets. BUT,

Is there any query in MySQL that can insert every row of an Excel spreadsheet into a database table?

MySQL cannot access XLS/XLSX. Save your file to .CSV then import your data with LOAD DATA. — Akina, Jun 21 '23 at 07:14

score 0 · Answer 1 · answered Jun 21 '23 at 08:22

0

To answer question as stated, no there is no query in MySQL importing from an excel sheet

answered Jun 21 '23 at 08:22

Civette

1 Answers1