Avatar of Sandra Smith
Sandra SmithFlag for United States of America asked on

Check to see if report data for a date already was imported - ACCESS 2003

I have an import process that, while the users aer suppoed to run every day, they may run i tonly once for three days.  I need to check each time the upload is done if it has already been imported.  Not too much of a problem if they stick to the schedule of everyday, but the don't.  So, what would be a quick way to check a temp table data that has been uploaded for, say, three day's worth of inforamtion again the permanent table to be sure none of the days (if any) have not already been brought in?  that is someone could have imported 8/15 data, not told anyone and the next person imports data for 8/15, 8/16 and 8/17?  I would need to inform the user of the duplication data information (should that be another questions?)  This is an ACCESS 2003 database pulling information from a text file.

Sandra
Microsoft ApplicationsMicrosoft DevelopmentMicrosoft Access

Avatar of undefined
Last Comment
Sandra Smith

8/22/2022 - Mon
Rey Obrero (Capricorn1)

do you have a field to store the Date the file was imported?
ASKER
Sandra Smith

Yes, I always use a datestamp field in this type of table.
ASKER CERTIFIED SOLUTION
Rey Obrero (Capricorn1)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Sandra Smith

there is a report data generation date.  Thank you, that works.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck