Jason Pruim 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]
What is the first line in your text file? Also, can you provide a
DESCRIBE of the table you're trying to insert into?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
