Hi - I am relatively new to MySQL, previous experience is mainly Visual FoxPro and MS SQL2000.
I have a client who supplies data in text files. In numerous of these files and subsequent tables there are date fields. In the UK we use the date format of dd/mm/yyyy. I understand that MySQL only accepts data in yyyy-mm-dd, and as far as keeping the data in MySQL I don't have a problem with that, but somehow I have to get the data into MySQL tables from the text files. In SQL Server, I can do this using some VB script in a DTS... is there anything similar, or, does anyone have any other ideas? Many thanks Andrew ____________________________ JM Data Services 8 Stanton Road Wimbledon LONDON SW20 8RL t: 020-8286 8545 f: 020-8944 8621 m: 07801-866043 e: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
