My replies seem to never send to the mysql-list
but to the ppl who sent a request only, so
I am forwarding this again.
Maybe it will help other ppl as well :)
Nessi
>Date: Wed, 13 Jun 2001 11:36:41 +0100
>To: "Ute Hoffmann" <[EMAIL PROTECTED]>
>From: Nessi <[EMAIL PROTECTED]>
>Subject: Re: Access Database into mysql
>
>Hi there,
>
>I had to do the same thing.
>I guess I did it the hard way since I didnt have any modules or perl.
>It took me some time to figure it out and I wrote a little procedure:
>
>[schnipp]
>
>3. Load data into table from *.txt:
>
>LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
>INTO TABLE tbl_name
>
>Example:
>(You have to upload the txtfile onto the server (here root), log into the
>database, use database, then command line:)
>
>load data infile „/something.txt“ into table tablename fields terminated
>by ‘;’;
>
>Be sure to use ; as delimiter NO ‘ or “ around the fields AND replace all
>‘ with \‘, " with \" and ; with \; in the contents.
>
>[/schnipp]
>
>When you export make sure to use some delimiter you are sure isnt in the
>database like # or \, for paranthesis choose {none},
>then replace all the "'; etc as mentioned above, then replace the
>delimiter with ;
>
>This has worked for me...hope it helps you or anybody else! :)
>
>Cheers, Nessi
