I am currently using MySQL 4.1 Win2K version along ODBC 3.5.1 Driver I am having trouble using the following LOAD DATA INFILE to import a txt, comma delimited file into to a Mysql Table.
Actually the only problem is the date field loading into mysql 4.1. I have defined the field as a date, datetime and timestamp. Where I am having trouble is the date in the second group below. I am receiving the information as "12/06/2003". All fields load fine with the exception of the "12/06/2003" field. All I get is is 0000-00-00 00:00:00 for the value of this field. Can anyone point me to the right direction on how I can successfully load the date with the "12/06/2003" format without getting 0000-00-00 00:00:00 everytime. Thanks for your help and time. Lenny Sorey LOAD DATA INFILE "d:/mydir/myfile.Tmp" INTO TABLE dealervehicle FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n'; (CIDLOTD,CVIN,CSTOCKNUM,CDISPOSITI,CMAKE,CMODEL,CYEAR,CMILEAGE,CBODYTYPE,CENGINE,CENGINESIZ,CINDUCTION,CTRANSMISS, CCOLOR,CPRICE,CCOST,CWARRANTY,CWARRANTYT,FWARRANTY,FWARRANTYT,FWARRANTYC,CPC_LABOR,CPC_PARTS,CWARRMONTH,C WARRMILES,CMANUF_MON,CMANUF_YEA,CSERVICEAG,DDATE_IN,DDATE_REMO,O1,O2,O3,O4,O5,O6,O7,O8,O9,O10,O11,O12,O13,O14,O15,O1 6,O17,O18,O19,O20,O21,O22,O23,O24,O25,O26,O27,O28,O29,O30,O31,O32,O33,O34,O35); "Dealer Name","2FMZA5145YBC70950","6641","A","FORD","Windstar LX","2000","65969","MINI VAN","V-6","3.8","SEQUENTIAL-PORT F.I.","AUTOMATIC WITH OVERDRIVE","Red"," "," ","Y","L","C1"," "," ","50","50","90","3000","08","1999","Y","12/06/2003","/ /","POWER STEERING","POWER BRAKES","POWER DOOR LOCKS","POWER WINDOWS","AM/FM STEREO RADIO","CASSETTE PLAYER","RADIAL TIRES","GAUGE CLUSTER","TRIP ODOMETER","TACHOMETER","AIR CONDITIONING","TILT STEERING WHEEL","CRUISE CONTROL","TINTED GLASS","DRIVER SIDE AIR BAG","PASSENGER SIDE AIR BAG","RECLINING SEATS","","ALLOY WHEELS","BODY-SIDE MOLDING","LUGGAGE RACK","CLOCK","INTERVAL WIPERS","REAR DEFROSTER","REAR WINDOW WIPER","CONSOLE","CARPETING","DAY/NIGHT LEVER","DUAL SPORT MIRRORS","DRIVER SIDE REMOTE MIRROR","FRONT BUCKET SEATS","CLOTH UPHOLSTERY","THIRD SEAT","CENTER ARM REST","COURTESY LIGHTS" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
