At 02:49 PM 4/06/2004 +0200, you wrote:

> > >LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
> >
> > OK, forget all that syntax. The nearest equivalent is
> > CREATE TABLE <table-name> EXTERNAL <filesystem-path-name> (see
> > LangRef.pdf). Your input file needs to be in fixed field format. This
> > allows you to query the external data file as though it were a table. You
> > can, for example, write a stored procedure to massage the data and store
>it
> > in any way you like.
>
>Oh yeah, doing it in a stored procedure is sooo much easier
>than in Delphi :-)

Yeah, and it's fairly unlikely a MySQL migrant would be around Delphi. :-)

/h