Import query help

  • Thread starter Thread starter test guy
  • Start date Start date
T

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-
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thanks STeve.. I'll check it out.

[MVP] S. Clark said:
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Click to expand...
 
Back
Top