Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Appending data

Status
Not open for further replies.

pitbull

IS-IT--Management
Jun 21, 2001
12
GB
I am receiving data from an external source on a weekly basis, does anybody know how I can append the records so that current records are modified so show the new status.
 
Dare I say, Write a bit of Code!

Errmm, seriously, there is an example just like this in the access manual and any reference on access will give you a very similar example.
What source is your data coming in as? From Excel or some other source?
I'm sure you'll get a more detailed answer soon, but basically you need to convert the manual process you do each week into a script which does it automatically.
Good luck.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top