Recommend this page to a friend! |
All requests | > | Import Excel CSV into MySQL table | > | Request new recommendation | > | Featured requests | > | No recommendations |
by RAJESH BHATT - 9 years ago (2015-07-17)
+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. |
+3 | by Manuel Lemos 23985 - 9 years 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 | |
|