Is Possible Import TEXT file with Condition?

  • Thread starter Thread starter Vadhimoo
  • Start date Start date
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
 
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;
 
Back
Top