>Hello,
>I downloaded the worldcities list in .txt format and created two identical tables where one
>is referencing this external file. When I launch the insert with a select from external table,
>all goes fine.
>The problem is the data received in the real table do not match and number of rows is not the
>same as from txt file. Fields are separated by comma and I removed the first line (fields
>names) Is anyone can explain me where I am wrong ?

What do you mean by 'separated by comma', Zoe? Files used as external tables must be fixed length, not delimited. Also, use CHAR and not VARCHAR when declaring the external table.

HTH,
Set