Mysql question

Discussion in 'MySQL' started by kool002, Nov 7, 2007.

0
  1. #1
    Hi,
    I have a file test.txt that has data like...

    "1","test","test","10",
    "2","test2","test2","20",

    When I use phpmyadmin and import the data it works fine, no problem there.

    Now when I open the file in MS excel and make some changes in this file and save it.
    the import fails.

    The problem is MS excel is saving the data without " and mysql looking for "

    So I guess my question is how do I make changes in MS excel without changing the format (quote ) around field.

    or any other suggestions?
     
    kool002, Nov 7, 2007 IP
  2. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #2
    You can use the Openoffice Calc program to open the MS Excel
    file and save it as "Text CSV". While saving, you can specify your own
    field delimiter and Text delimiter.
     
    Kuldeep1952, Nov 7, 2007 IP