Print Page | Close Window

UpdateDirect.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.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=227
Printed Date: 28 Mar 2024 at 8:55am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: UpdateDirect.mdb (intermediate)
Posted By: Roger Carlson
Subject: UpdateDirect.mdb (intermediate)
Date Posted: 16 Jul 2008 at 10:29pm

 
Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

UpdateDirect.mdb

This sample illustrates how to programmatically update a table directly from a text file. The scenario is that there must be a file called "ShoeImport.txt" in the same drive as the database. You can create this file by clicking the "Export Table to Text File" button. 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.

The "Simple Import" runs the import without a status bar. The "Advanced Import" brings up a status bar to show progress.

Download
Access 97 (114 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/UpdateDirect97.zip - uploads/5/UpdateDirect97.zip
Access 2000 DAO (117 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/UpdateDirect2k.zip - uploads/5/UpdateDirect2k.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net