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 wrote:
I have created table in mysql with 12 fields
Field1Field2 Field3 Field4 ……… Field12
I have an excel sheet with 12 columns and 150 rows.
My question is how can I import all of the columns from the excel sheet to my table without losing any information.
-
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.
--
Andrew Dashin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
