Save a Variable's Value

[BOONER]

How do you save a variable's value into a lookup table? I need to save the
filenames of files that are imported into my database using VBA. I have a
weekly process that imports all of the files in a given folder. Currently,
the code deletes all of the records in my table before the import (to avoid
duplication). I would like to re-write the code to only import files that
have not already been imported. If there is an eiser way to accomplish this,
I would appreciate the imput. Either way, I would like to know how to save
the variable's values for future use. Oh yeah, this is all response data and
duplicate records must be allowed in the table.

 

[Gina Whipp]

Booner,

You say you have code that deletes all the records in your table. Well,
just a thought but could you copy/paste that so just the lines that need
adjustment can be changed, it would make it easier for the voulenteers here.

 

[Van T. Dinh]

I think it may be easier to move the file to a *different* folder as soon as
the importing of this particular file is completed. This way, you know that
all files remaining on the folder are to be imported ...