Recommend this page to a friend! | Stumble It! | Bookmark in del.icio.us |
All requests | > | Import Excel CSV into MySQL table | > | Request new recommendation | > | Featured requests | > | No recommendations | ||
by RAJESH BHATT - 7 months ago (2015-07-17) import csv to mysql table
+1 | I have tables in MySQL database. This is the structure of my database tables: table 1 - tbl_main_categories:
table-2(tbl_sub_category)
table-3(tbl_products)
My excel sheet data as follows(product.xls) row-1
row-2
row-3
row-4
My problem: How to import file product.xls to MySQL table (tbl_products), as it contains ids from table tbl_sub_categories where as in my Excel there is name of sub_categories? Please suggest me a library as I am beginner to PHP world. |
+1 | by Manuel Lemos 11100 - 6 months ago (2015-07-20) Comment You can use this class if you export your Excel spreadsheet to the CSV format. It is important that the spreadsheet headers match the database field names. |
Recommend package | |
|