Save a Variable's Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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 ...
 
Back
Top