Using IIF to prevent duplicate Imports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Easiest way would be to create a query that compares the temporary table to
the "permanent" one.

Open a recordset based on that comparison query. If the recordset is empty,
you know it's safe to import the data. If not, issue your message.
 
Thanks!

Douglas J. Steele said:
Easiest way would be to create a query that compares the temporary table to
the "permanent" one.

Open a recordset based on that comparison query. If the recordset is empty,
you know it's safe to import the data. If not, issue your message.
Click to expand...
 
Back
Top