<div>
There are many available tools for importing. EMS Mysql Quick Import - <a href="http://ems-hitech.com/quickimport" rel="ugc">http://ems-hitech.com/quickimport</a>&nbsp;is one of the good and easiest way. You have a fully functional trial version of 30 days.
</div>


There are many available tools for importing. EMS Mysql Quick Import - http://ems-hitech.com/quickimport [http://ems-hitech.com/quickimport] is one of the good and easiest way. You have a fully functional trial version of 30 days.

<div>
Nodding draconius's way, I find it more reliable to save the excel data as Tab Delimited Text and import in the same manner.<br />
<br />
Discuss?<br />
<br />
Mike
</div>


Nodding draconius's way, I find it more reliable to save the excel data as Tab Delimited Text and import in the same manner.

Discuss?

Mike

<div>
I agree. &nbsp;In fact that's just what I said, but a bit shorter. &nbsp;:o)
</div>


I agree.  In fact that's just what I said, but a bit shorter.  :o)

<div>
I ended up using the cvs and phpMyAdmin insert data from textfile. &nbsp;worked great<br />
<br />
thanks - Trevor
</div>


I ended up using the cvs and phpMyAdmin insert data from textfile.  worked great

thanks - Trevor

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have two .xls documents that i want to import into a table in my mySQL database. &nbsp;What would be the quickest way to do this? &nbsp;I'm using phpMyAdmin 2.5.4<br />
<br />
Thanks<br />
<br />
Trevor
</div>
</div>


Hi,

I have two .xls documents that i want to import into a table in my mySQL database.  What would be the quickest way to do this?  I'm using phpMyAdmin 2.5.4

Thanks

Trevor

xls to mySQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.