Importing hyperlinks

  • Thread starter Thread starter Isidore
  • Start date Start date
I

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
 
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"
Click to expand...

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.
 
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
 
Back
Top