Importing hyperlinks

[Isidore]

I'm trying to make a table tracking all of the files in a certain
folder in my computer, one record for each file.

I'd like one of the fields to be a hyperlink to the actual document.
Is there a way to copy or import all of the files in a folder from
Windows Explorer into a column in an Access table?

Thanks in advance,
Isidore

 

[John Nurick]

Hi Isidore,

One way is to use the Windows command line to create a text file
containing the list of file names.

Open a command prompt (MS-DOS Window) and use a command like this,
substituting the actual path to the folder

DIR "D:\Folder\Folder\*.*" /B /ON

When this is producing the results you want, add > and the name and
location for the text file containing the names, e.g.:

"D:\Folder\File.txt"

and run the command. This produces a list with all the file names in the
folder in alphabetical order, which Access can import or link to a
temporary table.

If you want to include the files' timestamps and sizes, try
/-C /A-D
instead of
/B
but you will need to edit the file to delete the header and footer lines
and put delimiter characters between the fields so Access can import it
cleanly.

 

[Isidore]

Thanks for the reply. Unfortunately, the method you suggested only
yields file names without the path. I tried open this list in Word
and using global replace to attach the path to every item, but even
here, when I paste the list into Access, the links still have to be
entered manually.

Thanks again,
Isidore