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]
