Import data into mysql database from Excel with php

Dear Experts,

I've got a big list which is waiting for import into mysql. :) It has more than 100 columns and above 7500 rows. These datas are in an excel file.
I'd like to import the content of file into mysql, but I don't know what's the best method. Is it possible to create a script what takes the first line of spreadshit and creates the table based on the values of this line.
Then it imports the rest as values into table?

Thank you Experts!
peterjanosiAsked:
Who is Participating?
 
DonkeyOteConnect With a Mentor Commented:
You could perhaps also consider creating a .csv file and importing that:

http://www.tech-recipes.com/rx/2345/import_csv_file_directly_into_mysql/
0
 
harryhelpCommented:
In the past, I have imported content on Excel using Phpmyadmin. Your host should provide it, or you can download it from - http://www.phpmyadmin.net
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.