Using If or IIF to find duplicate records in different tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ndel40 (Ndel40_at_discussions.microsoft.com)
Date: 10/12/04 

Date: Tue, 12 Oct 2004 04:13:07 -0700

I have a table that is populated with data by importing a text file created
from a SAP download once per week. I have automated the process, however, I
see a potential problem with duplicating data due to overlapping SAP download
date ranges.

In order to prevent duplication, I would like to import the text file to a
temporary table, create a concatenated field for several of the imported
fields and compare the concatenation to the same concatenation in the master
table.

I would like use and “if” statement that does the evaluation and if no
duplicates are found the data is imported and appended to the master table.
If duplicates exist, find the max data and time from the master table and
display a message… something like this:

If no duplicated records exist then

Import the text file and append it to the master data file
Else
Display a message that says “Data already exists – The last record imported
was 10/11/04 12:31:00 PM. Please re-run the SAP download”

Endif

I’m sure there are other ways to accomplish what I need… any ideas are
welcome.

FYI… I am using Access 97.

Thanks,

Nick

Relevant Pages

  • Compare two tables and look for duplicates
    ... I have a table that is populated with data by importing a text file created ... see a potential problem with duplicating data due to overlapping SAP download ... duplicates are found the data is imported and appended to the master table. ...
    (microsoft.public.access.macros)
  • Using IIF to prevent duplicate Imports
    ... I have a table that is populated with data by importing a text file created ... see a potential problem with duplicating data due to overlapping SAP download ... duplicates are found the data is imported and appended to the master table. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using IIF to prevent duplicate Imports
    ... > Open a recordset based on that comparison query. ... >> I have a table that is populated with data by importing a text file ... >> duplicates are found the data is imported and appended to the master ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using If or IIF to find duplicate records in different tables
    ... >> I have a table that is populated with data by importing a text file created ... >> fields and compare the concatenation to the same concatenation in the master ... >> duplicates are found the data is imported and appended to the master table. ...
    (microsoft.public.access.queries)
  • Re: Merge Fields in Excel Import
    ... >> I am both exporting and importing from the report master, so as you said, ...
    (microsoft.public.project)