I believe that excel files generally terminate lines with '\r\n' and if you use terminated by '\n' it will cause this behavior. so try it with lines terminated by '\r\n' or get TextPad or a similar editor that can save the file as unix platform that uses the same line terminators that MySQL expects by default and leave out the optional "terminated by"
cj On 8/8/07, Jason Pruim <[EMAIL PROTECTED]> wrote: > Okay, so I have been going crazy trying to figure this out... > > All I want to do is load a excel file (Which I can convert to just > about anything) into a MySQL database... Should be easy right? > > Here is the command that I have tried: LOAD DATA LOCAL INFILE '/ > volumes/raider/AML.master.txt' INTO TABLE current FIELDS TERMINATED > BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\n'; > > and here is the error I am getting: | Warning | 1264 | Out of range > value adjusted for column 'Record' at row 1 | > > What do I need to change to get this to work? Or what other info do > you need to be able to help me? :) > > Thanks! > > > -- > > 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]
