i dont want to use spreadsheet::pa rse module?i want to insert bulk data directly to mysql table in bulk
how to insert data in mysql table directly from excel sheet?
Collapse
X
-
-
Save the spreadsheet as a csv file then use the mysql "LOAD DATA INFILE" statement to import it into the db.Comment
Comment