Your daily news about web technology, interface and design.

Sorry about the current website getting messy,
we are currently moving to our new wordpress platform "webmasterbulletin.net".
> webXadmin Opensource Projects and Commercial Applications > Php, Excel & Mysql Tools
 
Convert your excel sheets to mysql data with xls2mysql (php)

We are proud to announce xls2mysql Version 1, the first and only application that performs data conversion from xls to mysql. try it and help us improve its features !

Intended audience : Developpers

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 :

 



Comments are temporarily disabled because of SPAM
 Discussion / comments
2006-03-17
Joyce comments from New Mexcio :
I need to convert excel files to mysql (in fact, i need to insert into informax database). Each file has three sheets. Can your software convert them at one process?
 Post a reply to this comment

 Read this discussion thread
(2 messages)
2006-01-22
dude comments from here :
I have a 15 meg file and unfortunately this program poops out after 30 secs. Is there something I can get that will handle the conversion of such a large file?
 Post a reply to this comment

 Read this discussion thread
(2 messages)
2006-01-20
Napalm comments from Paris, France :
Wow, exactly the tool i was seeking, works perfectly and very simple to use even for a total php/mysql noob like me.
Merci les gars !
 Post a reply to this comment
2005-12-29
Them comments from Amsterdam :
Found that MySql does not mind spaces in Field names, heads look even beter, so just loosing the hyphen would work.
Thanks Erwan
 Post a reply to this comment

 Read this discussion thread
(5 messages)
2005-12-29
Them comments from Amsterdam :
HI Great job
it Almost works! there are 2 little things to change and the sql is rendered OK

do not have skill enough to change myself ,

1. all spaces in excel COLUMN HEADER names are changed to an hyphen - in the mysql FIELD names The sql does not like that

better change the spaces into underscores as in Field_Names
thus create table tblname ( field_name varchar(255));

2. last character is choped off from every cellvalue
all header cells and all cells from row1 to eof mis the last character
(i mean data vallue stream read out got chopped off 1 )

hope this was helpfull
this is a great script
please keep me posted
Thank You
Them Cuiper




 Post a reply to this comment
2005-12-13
Ersin comments from Turkey :
nice work but i have charset problems :)
 Post a reply to this comment
2005-12-12
Bustergut comments from London :
After I worked out that you have to USE a database first it worked OK. Had trouble with large files though well below 2MB. Kept getting a time out after 30s from a file within xls2mysql. (.inc) Good stuff though and await next release.
 Post a reply to this comment
2005-12-05
amnhak comments from iran :
is cery very good
 Post a reply to this comment


Most read :
  • php move file (12790 readers).
  • Excel : export to a text file with a chosen delimiter (11473 readers).
  • String replace (7582 readers).
  • Oracle autoincrement columns (7343 readers).
  • Flash Photo Gallery using xml and php : demo & download (6527 readers).
  • Flash Page turn effect : goto PAGEFLIP (6432 readers).
  • Replace string in file with sed (6349 readers).
  • mysql replace string in a query (6141 readers).
  • Read Excel Spreadsheet with PHP (5843 readers).
  • Shell : rename all files in subdirectories to lower-case (5622 readers).

  • download webxadmin
      Support webxadmin !
    donate
    Donators get sitescope OS
      > About webxadmin
    > Site map
    > Contact the author :
    webxadmin at free dot fr

    Pôle Ouest - web design services and opensource consultancy - Quimper Brest Lorient Douarnenez Carhaix
    Google

    Pôle Ouest - web design services and opensource consultancy - Quimper Brest Lorient Douarnenez Carhaix

    Excel2Mysql converts Excel sheets to Mysql insert queries

    Flash Photos Viewer : Eyelash

     Use OpenOffice.org



    Free Software and Game Downloads