Import query help

[test guy]

I currently have an import process in place including an append query to
bring delimited data into my table. It currently ignores duplicates keying
off of a specific field, thus only importing the "new" records.

What I need to do, is rewrite the process so that it continues to import the
new records, but ALSO import records where a specific field is set to true,
which is to say that the field is being used as an update flag.

Thoughts from the masses on how I could do this?? Thanks in advance-

 

[[MVP] S. Clark]

Create an Update query that updates any matching records, where the flag
field is true.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[test guy]

Thanks STeve.. I'll check it out.

Create an Update query that updates any matching records, where the flag
field is true.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-