how to insert data in mysql table directly from excel sheet?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jaydip650
    New Member
    • Apr 2013
    • 1

    how to insert data in mysql table directly from excel sheet?

    i dont want to use spreadsheet::pa rse module?i want to insert bulk data directly to mysql table in bulk
  • ananth krish
    New Member
    • Feb 2014
    • 1

    #2
    how to convert accdb file to mdb file format......... .

    Comment

    • RonB
      Recognized Expert Contributor
      • Jun 2009
      • 589

      #3
      Save the spreadsheet as a csv file then use the mysql "LOAD DATA INFILE" statement to import it into the db.

      Comment

      Working...