Importing hyperlinks

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"

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.



On Fri, 07 May 2004 12:16:06 GMT, Isidore wrote:

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 [Microsoft Access MVP]

Please respond in the newgroup and not by email.

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

On Sat, 08 May 2004 19:00:22 +0100, John Nurick
wrote:

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.



On Fri, 07 May 2004 12:16:06 GMT, Isidore wrote:

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