Updating a Specific Value in a Table of Values

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JohnC (upperquad_at_hotmail_delete_.com)
Date: 09/27/04


Date: Sun, 26 Sep 2004 20:50:20 -0500

I have a table of values similar to:

table Name tblValues
Field1 VALUE_NAME (text)
Field2 VALUE (text)

The MDB file is on a LAN file server. I have an import routine (OBDC to
Oracle) that I run occasionally from another MDB that copies the data to the
LAN file server MDB.

When I run the import, I need to update the value for IMPORTDATE in
tblValues to be the date that the import routine is run. (I think this will
need to be a string value because VALUE is text.)

JohnC



Relevant Pages