import filenames

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

Guest

Forgive me, I am very New in this. Need some help please. I have to import
all the filenames that are Currently in Folder C:\FMS\FMSphotos into an
access table. Some of those are jpg files, other pdf files.

How do I do this

Thx
Elly
 
Hi Elly,

I do this by creating a text file containing the file names, and
importing that.

1) Open a command prompt ("DOS prompt")
2) Use the CD command to navigate to the folder you want (e.g.
CD "\FMS\FMSPhotos"

3) Use the DIR command with /B to create a text file containing the
names of the JPG files:
DIR /B *.jpg > "\FMS\List of file names.txt"
and then to append the names of the PDFs:
DIR /B *.pdf >> "\FMS\List of file names.txt"

4) Back in Access, import the text file.
 
Back
Top