Is Possible Import TEXT file with Condition?

V

Vadhimoo

Dear All,
Is it possible to Import the TEXT file with condition?
for example:

CityNo CityName
001 USA
091 INDIA
091 INDIA
091 INDIA
001 USA
044 UK
.... ....


I would like to improt the data from text file where CityNo=001.
Is it possible ?
Thanks in advance your reply.

Thanks and Regards,
vadhimoo
 
K

Klatuu

Not during the import itself. You will have to import the file, then create
a query to extract only those rows you want. For example, you could use a
delete query to delete rows where the CityNo is not 001.
If you import CityNo as text:
DELETE * FROM ImportedTableName WHERE CityNo <> "001";

If you import CityNo as numeric:
DELETE * FROM ImportedTableName WHERE CityNo <> 1;
 
Top