Re: Using IIF to prevent duplicate Imports
From: Ndel40 (Ndel40_at_discussions.microsoft.com)
Date: 10/12/04
- Next message: Dale: "Recordset to update table: different approach not any faster..."
- Previous message: gone4fishn: "how to create a counter using alphabet and numbers (0-Z)"
- In reply to: Douglas J. Steele: "Re: Using IIF to prevent duplicate Imports"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 12 Oct 2004 15:37:02 -0700
Thanks!
"Douglas J. Steele" wrote:
> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
> "Ndel40" <Ndel40@discussions.microsoft.com> wrote in message
> news:62B7525C-C4A7-45BD-8438-CAB2304BCFE8@microsoft.com...
> > 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
> >
> >
> >
>
>
>
- Next message: Dale: "Recordset to update table: different approach not any faster..."
- Previous message: gone4fishn: "how to create a counter using alphabet and numbers (0-Z)"
- In reply to: Douglas J. Steele: "Re: Using IIF to prevent duplicate Imports"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
