> In that case they are probably fixed width files. If they are not fixed > with and are in fact delimited by tab or comma, you can use LOAD DATA to > bring them in. > > See http://www.mysql.com/doc/en/LOAD_DATA.html
And if they are fixed width, you can write a script in something like Perl to unpack the records into a comma or tab delimited format, and then use LOAD DATA to load the data into MySQL. Of course, the delimiter character may appear in the data, so you'll need to escape those as you unpack them. You'll want to consult the PICs while you are building the script, of course. -- Joel Rees, programmer, Kansai Systems Group Altech Corporation (Alpsgiken), Osaka, Japan http://www.alpsgiken.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]