Stengel Christian wrote:

> Hi Mark,
>
> you can declare an Table as an external file and use
> this to import your data:
>
> The file.txt is the file with your millions of
> records. After that you can insert them into another
> table by insert into select from statement.
>
> That sould be the fastest way.
>

I did wonder about this.... surely this is about the same as reading the
file and inserting?
(possibly even slower if I have to rewrite the file in fixed format first?)

cheers

Mark