Hi Hiep,
Here's what I do when I need to do that. First save it as a .csv file
and then follow this:
load data infile '/path/to/file' into table MyTable fields terminated
by '\t' lines terminated by 'w'
that has always worked for me.
Hope it helps!
On Jan 14, 2008, at 10:51 AM, Hiep Nguyen wrote:
hi everyone,
i have a large ms excel data (text) file that i need to import to my
table in mysql. does any one have a suggestion how to do this? i'm
try to export to csv file, then import to my table, but i have so
much problems with delimeters
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]