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.
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 a
Hi,
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 a
mysql table on a remote linux server.
