Importing data from Excel into MySQL database |
||
| Importing data from Excel via text files
(csv files) into MySQL database is important and useful. You need to
create your data according to the fields in your table. The data is
seperated by commas and enclosed in quotes (" "). The process is simple
and quick. Log into your MySQL database server using your 'login' and
'password', select your database, then the relevant table. Next click
on import and follow the steps carefully as shown in the training video. |
||
|
||
|
|
||