Importing file names into a table?

[klu...@hotmail.com]

Hi All,

I have a folder with 8582 different documents in it. They are .doc .pdf
.tif and .rtf formats.
All the file names for these files are a string of 11 number and
sometimes a letter at the beggining and/or end. I have a table in
Access that has 35175 records in it. Each record has a field called
ATCH_GIN that contains a value in the same format, 11 number string
with a letter at the beggining and/or end. (Does not have the file ext
though.) I only need to keep 8582 of these records. (The ones whose
number in the ATCH_GIN field match one of the file names in the
document folder I have.) I was thinnking of running a 'find unmatched'
query so that I can delete the records I don't need but to do that I
will need a table that has the 8582 file names in it. Not sure if I can
import just the names into a table or what I should do. I really don't
want to enter all of them by hand, cause if I goof it will not be fun
to fix. Any help is great!

Thanks,
Bill