Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Nov 2006
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel to mysql conversion

    I know its a little off topic, but I was wondering if anyone knows of any freeware excel to mysql conversion utilities? There are a lot of pay ones floating around but was hoping for a free one.

  • #2
    Senior Coder timgolding's Avatar
    Join Date
    Aug 2006
    Location
    Southampton
    Posts
    1,519
    Thanks
    114
    Thanked 110 Times in 109 Posts
    I can dig up a Excel reader that reads Excel spreadsheets I use it to ouput to a table, so you would have to decode and implement to get it to insert data to SQL. I had to decode it a bit myself and it wasn't to tricky.

    Heres an example http://www.jamiesmicroprop.org.uk/sales.php The client inputs changes to the price structure in an excel xls file i then simply upload it to the server and my sales.php page uses the reader.php to show the data as a table.
    You can not say you know how to do something, until you can teach it to someone else.

  • #3
    Senior Coder timgolding's Avatar
    Join Date
    Aug 2006
    Location
    Southampton
    Posts
    1,519
    Thanks
    114
    Thanked 110 Times in 109 Posts
    I tried to paste the code but coding forums is strict on char counts so I will host it for you because i am very nice

    http://pinman-designs.co.uk/files.rar

    one is the relavent php from sales.php the other is the reader itself enjoy
    Last edited by timgolding; 11-24-2006 at 03:02 PM. Reason: insert link to files
    You can not say you know how to do something, until you can teach it to someone else.

  • #4
    Regular Coder
    Join Date
    Nov 2006
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ahh cool thanks, I just cheaped out and bought a program to do it. Thats a great script though.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •