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]

Reply via email to