UpdateDirect.mdb (intermediate)

Please consider donating $1 per sample downloaded, find out why here
Access 97 (114 KB)

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




Need Winzip?

Return to Main Page