xls to mysql convertion

Discussion in 'PHP' started by Balamurali, Mar 21, 2008.

0
  1. #1
    Hai i have save the .xls file as .csv file for converting mysql, when i save the csv file the number is converted to scientific number. ex: in .xls file the number is 7209026127084, after save the file as .csv it ll show as some thing like 7.20903E+12. Please tell me how to solve this problem. thanks in advance:)
     
    Balamurali, Mar 21, 2008 IP
  2. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #2
    in excel, try to format that column as text first... then save as csv.
     
    daboss, Mar 22, 2008 IP
  3. Balamurali

    Balamurali Peon

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I saved the field name as text and then save the file as .csv, but the result as same scientific number.
     
    Balamurali, Mar 22, 2008 IP