Hi, sam
You can try to export table to file from Excel in CSV format.
And then import data from this file to mysql.
Something like this should help you:
LOAD DATA INFILE 'yourtabledata.txt' INTO TABLE yourtable FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
sam rumaizan
On Thu, 4 Jan 2001, TEXLID_SUPPORT wrote:
> Could anyone please let me know how I can transfer data from excel to
> a mysql database? If it is possible. The data is stored in an excel
> file on my PC. And I want to transfer the contents (about 500 records
> with 20 fields) of this excel file to
