0

Hi, I really need help with this. I read from various sources but they are complicated and I do not understand them at all. Is anyone kind enough to help how do I go about it?

Edited by Jiaxin: n/a

4
Contributors
5
Replies
7
Views
6 Years
Discussion Span
Last Post by atfOnly
0

Easiest way - output to csv and then use usual method:

LOAD DATA LOCAL INFILE '/importfile.csv' 
INTO TABLE test_table 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
(field1, filed2, field3);

there are also free sites out there that transform csv into sql.

if looking for excel to sql, you may have to use COM. or zend - php livedocx - may be similar thing for excel??

0

Easiest way - output to csv and then use usual method:

LOAD DATA LOCAL INFILE '/importfile.csv' 
INTO TABLE test_table 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
(field1, filed2, field3);

there are also free sites out there that transform csv into sql.

if looking for excel to sql, you may have to use COM. or zend - php livedocx - may be similar thing for excel??

test_table is the table name right? terminated by ',' need to change? what else do i need to change?

0

test_table is the table name right? terminated by ',' need to change? what else do i need to change?

Just the table name and the location of the csv file

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.