List:General Discussion« Previous MessageNext Message »
From:Jason Pruim Date:August 8 2007 5:15pm
Subject:Import file into MySQL Database..
View as plain text  
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
japruim@stripped



Thread
Import file into MySQL Database..Jason Pruim8 Aug
  • RE: Import file into MySQL Database..Stephen Sunderlin8 Aug
    • Re: Import file into MySQL Database..Jason Pruim8 Aug
      • Re: Import file into MySQL Database..Mark Kelly8 Aug
  • Re: Import file into MySQL Database..Gary Josack8 Aug
    • Re: Import file into MySQL Database..Jason Pruim8 Aug
      • Re: Import file into MySQL Database..Gary Josack8 Aug
        • Re: Import file into MySQL Database..Jason Pruim9 Aug
          • RE: Import file into MySQL Database..Edward Kay9 Aug
            • Re: Import file into MySQL Database..Jason Pruim9 Aug
              • RE: Import file into MySQL Database..Jerry Schwartz9 Aug
                • Re: Import file into MySQL Database..Jason Pruim9 Aug
                  • RE: Import file into MySQL Database..Jerry Schwartz9 Aug
  • Re: Import file into MySQL Database..Christian High8 Aug