If you can import your excel doc into MS Access I'd suggest: 
http://www.mysql.com/products/tools/migration-toolkit/

I just started using and love it -  easy intutitive GUI tool for importing
data into nySQL databases.

Good luck.



-----Original Message-----
From: Jason Pruim [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, August 08, 2007 1:15 PM
To: mysql@lists.mysql.com
Subject: Import file into MySQL Database..

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]

Reply via email to