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.
1. WHAT Does it do ?
- uses first line of the excel file to create sql columnss
- 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.
2. WHAT DOESN'T IT DO (YET)
- detect field types (numeric, text, longtext, unique)
3. Xls2Mysql requirements : you'll need php > 4.0.6
4. HOW TO USE xls2mysql :
- After payment has been confirmed (ses below), you'll get unlimited access to the xsl2mysql download adress.
- get 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 read/write rights on the xls folder.
4. HOW CAN I TRY & GET XLS2MYSQL ?
|
xls2mysql 's demo is available online : click here to try your Excel File ! |
xls2mysql is shipped as zip file for a fee of 15$. This fee helps us manage the time we spent on development and support.
For 15$ you get the application, 24hrs delay email support, and free upgrades during one year.
We welcome Paypal payments, and will be glad to help you work out xls2mysql if you encounter problems. Click on the buy now button to go ahead.
|
5. Screen shot :
