importing excel file into mysql database

Discussion in 'PHP' started by alimoses, Oct 30, 2010.

0
  1. #1
    I have my excel file containing my records, and I want info on how easily I can import an excel file into mysql database.
    Any help will be appreciated
     
    alimoses, Oct 30, 2010 IP
  2. Coranti

    Coranti Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    You can use PHPMyAdmin. It has an import function for Excel.
    You will need to structure your tables and the Excel file in such a way that the importer can match the fields easily.
     
    Coranti, Oct 30, 2010 IP
  3. yogabalan

    yogabalan Member

    Messages:
    106
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #3
    yogabalan, Oct 30, 2010 IP
  4. daljit

    daljit Well-Known Member

    Messages:
    312
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #4
    you can import the excel file using phpmyadmin.if you are still not able to do this please pm.
     
    daljit, Oct 31, 2010 IP
  5. Pedro Gorrin Diaz

    Pedro Gorrin Diaz Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    better convert your excel file into csv and try import from the phpmyadmin make sure each column matches your mysql table field
     
    Pedro Gorrin Diaz, Oct 31, 2010 IP