exel to mysql dump

Discussion in 'MySQL' started by PinoyIto, Aug 23, 2006.

0
  1. #1
    I have datas stored in microsoft excel, I have tried to covert the file to csv file and import it to PHPAdmin but no success.

    My suspect is that, the error cause by double quotes, and signle quotes....

    Is there a free program to convert excel file to mysql dump file?
     
    PinoyIto, Aug 23, 2006 IP
  2. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #2
    how important are the ticks anyways? (Personally, i always replace ' with `) Anyways, maybe just do the same with your sql data, then convert to csv. WIndow's Navicat has a TON of import/export options.
     
    ccoonen, Aug 23, 2006 IP
  3. sacx13

    sacx13 Active Member

    Messages:
    438
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    58
    #3
    Read this thread

    It should be clear enough to import your csv from command line.

    Regards
     
    sacx13, Aug 27, 2006 IP