> >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 :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com