More Import data help

[test guy]

Original issue: > 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.

I was told that I should use an Update query, but I'm uncertain how to
qualify that the query will ONLY update those records WHERE the keying field
= 1.

Does anyone have suggestions on building this query/process?

 

[Dennis Schmidt]

Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

I'm not sure what you're trying to update, however to make a query update
only records with a certain value in a field (like the value 1), simply
include that column in your update query and on the Criteria line, type
your limiting value.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[Adrian Leontovich]

Hi Dennis... when I do this, the query fails to update the data.. not sure
why. I'm fairly certain that all of the fields in the query are entered
properly... here's the context..

A macro performs a transfertext function to import text delimited values
into a table. Then I run an OpenQuery using the Update Query, where the
value of a key field =1, then the destination fields of the target table are
supposed to be updated. Then it runs another OpenQuery to perform an Append
Query to bring in the rest of the new records, ignoring duplicates.

Problem is, I think the Update Query is ignoring duplicates as well! Yes?
no? Any help is appreciated.