How do I import into an Access database a file directory?

#1 (**permalink**) 28-Jul-2006, 08:17 AM

I have several CD's on which there are several thousand file names of JPEG
files. I would like to import the file names (or even the file names in one
field and the JPEG image in another field) so that I can organize the files
in one database.

I know that Outlook allows you to print out a directory. Is there a way to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10983-how-do-i-import-into-access.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10983
"print" out the directory from Outlook so that it is in a strung-text format
and these files can be imported into an Access database? Your assistance is
greatly appreciated!

*

#2 (**permalink**) 28-Jul-2006, 08:17 AM

loop through the directories; and get a list of files and folders.

if you had a real-mans database like SQL Server; you could call
xp_cmdshell in order to push the results into a table; it's about 100
times more efficient than doing it in an obsolete MDB file.

koslow wrote:
> I have several CD's on which there are several thousand file names of JPEG
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10983
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10983
> files. I would like to import the file names (or even the file names in one
> field and the JPEG image in another field) so that I can organize the files
> in one database.
>
> I know that Outlook allows you to print out a directory. Is there a way to
> "print" out the directory from Outlook so that it is in a strung-text format
> and these files can be imported into an Access database? Your assistance is
> greatly appreciated!