Prevention of double record append

[quinto via AccessMonster.com]

I need to append records from a text file to a table, the text file has no
unique field or a way of identifying unique records. Usually I would append
the records and deleted them for the source files to prevent double append,
when I attempt to do that I get a massage that I cannot delete records from a
linked files. I attempted to concatenate some fields but there occasions that
would not produce a unique control therefore some records that are valid
would not be appended.
Is there a simple solution?
My knowledge of access was acquired from this board there I rally would need
a simple solution that I can apply.
Thanks for your anticipated support
Quinto

 

[pietlinden]

I need to append records from a text file to a table, the text file has no
unique field  or a way of identifying unique records. Usually I would append
the records and deleted them for the source files to prevent double append,
when I attempt to do that I get a massage that I cannot delete records from a
linked files. I attempted to concatenate some fields but there occasions that
would not produce a unique control therefore some records that are valid
would not be appended.
Is there a simple solution?
My knowledge of access was acquired from this board there I rally would need
a simple solution that I can apply.
Thanks for your anticipated support
Quinto

If you can link to the text file, you should be able to use the Find
Unmatched query wizard, and then just import/append the missing
records to the Access table.

 

[quinto via AccessMonster.com]

Thanks

I did not get a chance to make the editsbut I am sure it will work.

Thanks again

Quinto

I need to append records from a text file to a table, the text file has no
unique field  or a way of identifying unique records. Usually I would append

[quoted text clipped - 11 lines]
If you can link to the text file, you should be able to use the Find
Unmatched query wizard, and then just import/append the missing
records to the Access table.