Sometimes you want to import excel sheet to your MySQL DB table which contains Data for this table, the way bellow guide you how to do that:
1- Create Microsoft Excel 97-2003 Worksheet.
2- Place the table fields names in the first row.
3- Rename the sheet to your table name.
4- Go to your MySQL Admin page and open your DB and open your table.
5- Press on the Import tab and point on your document location.
6- Set the charset to UTF8.
7- Pick Excel 97-2003 XLS Workbook.
8- Check Column names in the first row.
9- Press "Go".
Mohammad Abu Hmead
No comments:
Post a Comment