.xls / csv files type data need to insert in MYSQL database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ahmurad
    New Member
    • Aug 2007
    • 19

    .xls / csv files type data need to insert in MYSQL database

    Dear brothers,

    I have some importnat files in MS Excell / CSV format. I know php. I want to insert these files into MYSQL database to generate reports.

    What are the techniques to insert the MS Excell / CSV files into MySQL?

    Your kind quick reply is highly appreciated.
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Originally posted by ahmurad
    Dear brothers,

    I have some importnat files in MS Excell / CSV format. I know php. I want to insert these files into MYSQL database to generate reports.

    What are the techniques to insert the MS Excell / CSV files into MySQL?

    Your kind quick reply is highly appreciated.
    Google for "LOAD DATA INFILE"

    Comment

    Working...