Excel data upload to mysql

Ask about general coding issues or problems here.

Moderators: gesf, Michalio

Post Reply
sheetal
New php-forum User
New php-forum User
Posts: 1
Joined: Thu Jun 23, 2022 2:26 am

Dear Sir I want to upload data from excel to mysql database table. I tried searching on google but they all have bugs.
User avatar
Michalio
Moderator
Moderator
Posts: 214
Joined: Sun Jul 18, 2021 1:33 pm
Location: Poland

You can not import data in the excel format, first you need to save the data as a CSV file then you can import the data with a builtin functionality: https://dev.mysql.com/doc/refman/8.0/en/loading-tables.html
Free coding lessons: https://php-forum.com/phpforum/viewtopic.php?t=29852
Post Reply