Do you have any experience with Perl? Perhaps a quick script would convert your tab delimited files to the proper format? Bradley
Cameron Murdoch wrote: > Hi all, > > I apologise if this question has been asked recently; I have checked the > list archives and could not see anything. This is my problem: > > I am trying to convert and import a fairly convoluted Filemaker Pro 5 > database to MySQL. I have exported the filemaker records as tab delimited > files and have managed to load them in to MySQL without too much problem. > However I have one issue: Dates. Of course MySQL stores dates in YYYY-MM-DD > whilst filemaker uses DD-MM-YYYY and so when I import my delimited text file > MySQL interprets the dates incorrectly. I can't seem to find a way of > changing the date format in Filemaker, nor can I figure out how to get MySQL > to convert the dates into it's format. Any help would be greatly > appreciated and I apologise if this is something simple but this is my first > entanglement with databases. > > I am using MySQL 3.23.49 running on FreeBSD 4-STABLE. MySQL was compiled > from the FreeBSD port. > > Thanks for your help, > > Cameron > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
