Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Archive: Reading Excel Sheet using PHP

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorprogrammer
    • CommentTimeOct 25th 2006
     
    Hi anyone knows how to export an excel sheet into mysql table?

    its urgent so you are are requested to help me as soon as possible.

    Regards
    • CommentAuthorjiosis
    • CommentTimeOct 25th 2006
     
    QUOTE(programmer @ Oct 25 2006, 06:56 PM) 15

    Hi anyone knows how to export an excel sheet into mysql table?

    its urgent so you are are requested to help me as soon as possible.

    Regards
    [/quote]

    First I should ask you to make sure your file is csv file otherwise open it with excel and save it as csv.

    Now, I can give you 3 options !

    1- Using phpMyAdmin
    2- Using a desktop software
    3- Using an online convertor

    I, personally prefer the options 3 and 2.

    2- A desktop software to convert csv to mysql:

    I found a lot of softwares , usually commercial versions but please take a look at this :

    My DB Studio

    ** I didn't use it ! I just found it while I had same problem.

    BUT the good solution is an online csv to mysql convertor:

    http://ceo4u.com/data/

    Tomorrow I will post another url (should find it in office) that I use for my projects and can't remember the url now.

    Hope it was useful,
    Thanks
    Jiosis

1 to 2 of 2

  1.