<div>
In the past, I have imported content on Excel using Phpmyadmin. Your host should provide it, or you can download it from - <a href="http://www.phpmyadmin.net" rel="ugc">http://www.phpmyadmin.net</a>
</div>


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 [http://www.phpmyadmin.net]

<div>
<div class="content wysiwyg-content">
Dear Experts, <br />
<br />
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. <br />
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.<br />
Then it imports the rest as values into table?<br />
<br />
Thank you Experts!
</div>
</div>


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!

Import data into mysql database from Excel with php

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.