- save the excel data to csv format and no need additional character between each column.
- open the csv file use notepad to make sure that each column separate by , (koma).
- at the AppServ, open the phpMyAdmin and select the database
- then open the table at the menu and select structure mode
- then select import menu then browse the csv file
- then select format file csv then select
- fields terminated by : , (koma)
- fields enclosed by : , (koma)
Saturday, May 09, 2009
import data to MySQL 5.0.45
please do below steps:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment