Import From text file

[Lisas4]

Hi,

i have a really primitive table.

Basically 1 field. "Keywords"

If I import new keywords (additional ones) via txt file into my table it checks for the ones that exist and imports only the new ones.

Unfortunately it updates the existing ones, what resets the formating i have done to the keywords, like color etc.

But the formating is a important factor for my base.

So i am wondering, is there a way to import new keywords without updating the existing ones.

I am thinking into a new table, than relate and compare. Am i thinking to complicated?

In one script I did, the loop does not work for some reason, it works until portal row 2 and than loops forever.

somehow the go to portal row next exit after last does not grab.

Please can anybody help me,

Thanks in advance. Lisa

Edited August 16, 2009 by Guest

[comment]

Try setting the Keyword field's validation to Unique, Validate always. Then change the import action to 'Add new records'.

the formating is a important factor for my base

This sounds like bad practice. If the formatting represents information about the keyword, use additional fields for storing this information. Then, if you like, apply conditional formatting to the Keyword field, based on the data in other fields.