Excel to Mysql? Any Idea?

Discussion in 'Services' started by hp420vc, Dec 17, 2006.

0
  1. #1
    Hi i just bought some flash games but they came with an excel spreadsheet for the description and game id and stuff. Is there any way to convert this into mysql so i can make it work.

    Anyone want to do it? i willing to pay.

    pm me
     
    hp420vc, Dec 17, 2006 IP
  2. shenron

    shenron Notable Member

    Messages:
    4,965
    Likes Received:
    374
    Best Answers:
    0
    Trophy Points:
    295
    As Seller:
    100% - 0
    As Buyer:
    100% - 24
    #2
    The easiest way is to covert that to access and then use the Mysql Database converter to make the sql file to import into Mysql using phpmyadmin.
    Also you can always save as csv and import it directly, but that may be a bit tricky sometimes.
     
    shenron, Dec 17, 2006 IP
  3. Adventis

    Adventis Guest

    Messages:
    66
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    An even easier way is to use phpMyAdmin, and save the excel file as a CSV file. Import that CSV into phpMyAdmin - might take a little modding about but it shouldn't take anymore than 10-15 minutes for experienced users.

    If you get stuck, add me to MSN or drop me an email at questionsofscience@gmail.com

    Andy
     
    Adventis, Dec 17, 2006 IP
  4. webspider2005

    webspider2005 Well-Known Member

    Messages:
    383
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    108
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #4
    I can do it for you. I will provide the files ready for uploading or I can I restore the file for you.
     
    webspider2005, Dec 17, 2006 IP