Hi David, There is no built in tool for fix length records. If I am importing the data once or just a few time I use M$ Access, just setup an ODBC connection and use the import facility in Access to bring the file in (it's very easy). Where I have to do this automaticaly I have written perl programs that parse the incoming data and build insert statements.
Hope this helps, Ken ----- Original Message ----- From: "David Yee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 6:49 PM Subject: Importing fixed-length records > Hi. How can I import a text file containing all fixed-length records into > MySQL? Is there a way to do it with LOAD INFILE? The text file was > originally designed for import into Oracle. Thanks. > > David --------------------------------------------------------------------- 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