B
BOONER
Okay,
How do you store a variable used in VBA to a look up table. I would like to
save the filenames used to create my tables in a seperate table. Right now,
I use a module that deletes all of the files in my table, and then imports
all files in a given folder into the recently emptied table. Every week I
have to run the code in order to pick up the new data. I would like to have
access store the filenames (in a lookup table) of each file that is imported.
Then I could just import the new files. This is all response data, so I
need to allow duplicate records. If there is an easier way to do this I
would appreciate the input. Either way, I would still like to know how to
save variable values into a lookup table.
How do you store a variable used in VBA to a look up table. I would like to
save the filenames used to create my tables in a seperate table. Right now,
I use a module that deletes all of the files in my table, and then imports
all files in a given folder into the recently emptied table. Every week I
have to run the code in order to pick up the new data. I would like to have
access store the filenames (in a lookup table) of each file that is imported.
Then I could just import the new files. This is all response data, so I
need to allow duplicate records. If there is an easier way to do this I
would appreciate the input. Either way, I would still like to know how to
save variable values into a lookup table.