Ahhhh... the one thing I can't do... I don't have Access to well...
Access... :)
Did some more testing, made a new table and matched the field names,
now it will load it without any errors, it's just only importing the
first row... Not the rest of the 934 records...
On Aug 8, 2007, at 1:20 PM, Stephen Sunderlin wrote:
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/mysql?
[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]
