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

Reply via email to