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
Sandra SmithRetiredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
do you have a field to store the Date the file was imported?
0
Sandra SmithRetiredAuthor Commented:
Yes, I always use a datestamp field in this type of table.
0
Rey Obrero (Capricorn1)Commented:
you can check  the date of the file against the import dates in the table, before importing.

how do you get the date of the file?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sandra SmithRetiredAuthor Commented:
there is a report data generation date.  Thank you, that works.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.