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 ?
Thanks a lot.

Zoe