Print Page | Close Window

UpdateImportSeekFind.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
Printed Date: 15 Aug 2020 at 4:54am
Software Version: Web Wiz Forums 12.03 -

Topic: UpdateImportSeekFind.mdb (intermediate)
Posted By: Roger Carlson
Subject: UpdateImportSeekFind.mdb (intermediate)
Date Posted: 15 Jul 2008 at 11:34pm

Please consider donating $1 per sample downloaded, - find out why here .


This sample illustrates how to programmatically update a table from a temp table. The scenerio is that there is a text file download which has already been imported into a temp table "ShoeImport". Each record has a code in the field TRNCOD which indicates whether the record should "A" add a new record, "U" update a record, "D" delete a record, or "R" skip the record. Additionally, if there is a "U" and no matching record exists, the record should be Added.

There are four variations in the indicated modules: SEEK method with no status, SEEK with status, FIND with status, and Direct from a text file. Go the module to see the code.

Access 97 (224 KB): - uploads/5/
Access 2000 DAO (238 KB): - uploads/5/

Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -