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

Posted on 2013-09-11
Medium Priority
Last Modified: 2013-09-11
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.

Question by:ssmith94015
  • 2
  • 2
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39484772
do you have a field to store the Date the file was imported?

Author Comment

ID: 39484792
Yes, I always use a datestamp field in this type of table.
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 39484922
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?

Author Closing Comment

ID: 39485207
there is a report data generation date.  Thank you, that works.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question