If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Importing hyperlinks
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. |
#3
|
|||
|
|||
Importing hyperlinks
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 |
Thread Tools | |
Display Modes | |
|
|