Get_FileNames_Generate_Table

[Guest]

I've got a number of pdf's located in seperate folders. The pdf filename
is a number representing a certain coding structure. I want to generate a
list of these codes in table form in Access (more than 80 000 records). Can
anyone guide me how to do this?

 

[Guest]

Use a DOS command by clicking on Windows START - Run and enter CMD then OK.

Type HELP DIR and enter to view your choices of data to extract.

Type the drive letter followed by a colon where the CD is at - press enter.

Type DIR *.PDF then enter to see the file data. Use the switches such as /s
that
lets you include files in subdirectories - You learned all about the
switches when you entered Help DIR.

To save that informatio to file end you command line (DIR/s /b *.PDF) with

C:\MyCDFile.txt

This saves the information to that file on your c:\drive.

You can then link to the text file.