xls2mysql

if you're using php, go straight to the point : click here to use xls2mysql

xls2mysql is shipped with a simple but easy to understand interface : one tab enables file uploading, the other displays the list of all files in the recipient directory. As such you can try the process many times without re uploading your file.

WHAT Does it do ?

uses first line of the excel file to create sql columns.
uses filename to create table
uses each following row (from 2 to N) to create inserts.
does not actually perform the sql : please copy and paste to your favorite sql admin interface.

WHAT DOESN'T IT DO (YET)

detect field types (numeric, text, longtext, unique)

HOW TO USE xls2mysql :

download the package 'xls2mysql.zip' and unzip it to a web folder that has PHP

run the xls2mysql.php page within your browser *

Upload the files or test from the sample xls files from the file list tab

Xls2Mysql uses :

Super-Simple DHTML Tabs, by Joshua Olson (Georgia, USA)

Sliding doors of css, by Douglas Bowman (San Francisco, California, USA)

Spreadsheet_Excel_Reader,