How to tell if a record exists in a table

[Marty]

Howdy All,

I getting update transactions from a flatfile, and want to use them to
update a table in a database. However, I first need to check to see if the
proposed new key already exists on the table. Obviously, there are many ways
to do this, but it must be a fairly common problem and was wondering if
anyone had looked into the most efficient mechanism?

Thanks,
Marty

 

[Steve Schapel]

Marty,

Import the data into a "holding table" in your Access database, and then
use an Append Query to put it into the required table(s) from there. If
the record already exists, it will not be included in the append.