xls2Mysql 1.0 review

License: Other/Proprietary License with Source File size: 24K Developer: Erwan Barzhoneg

0

xls2mysql project is an application to perform data conversion from XLS to MySQL.

xls2mysql is shipped with a simple and easy-to-understand DHTML interface that allows uploading and displays the files available for conversion.

Here are some key features of "xls2Mysql":
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.

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

Usage:

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
if you upload files, check that php has rad/write rights on the xls folder.

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.