Or load the date into a column date_str and then convert and copy the date into a column date AFTER loading.
Cheers /rudy ps: I already posted a function of how to convert this date format into a MySQL date format somewhere on this list (prev month I think) -----Original Message----- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003 14:08 To: Andre Winarko; [EMAIL PROTECTED] Subject: RE: Convert date from .txt file [snip] How do you convert a date dd/mm/yyyy from a .txt file into mysql date format when using LOAD DATA INFILE ? [/snip] LOAD DATA INFILE cannot do the conversion "on-the-fly". You could use a scripting language (sed, awk,etc.) to read and convert the dates. HTH! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]