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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

do you have a field to store the Date the file was imported?
Avatar of Sandra Smith
Sandra Smith
Flag of United States of America image

ASKER

Yes, I always use a datestamp field in this type of table.
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Sandra Smith
Sandra Smith
Flag of United States of America image

ASKER

there is a report data generation date.  Thank you, that works.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo