Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Importing List of Files in Folder
Name: EK Date: September 17, 2003 at 10:05:17 Pacific OS: Win 2000 Pro CPU/Ram: 128mb
Comment:
I have a folder that holds several hundred data files. I have to describe what each file does. I want to copy just the filenames in that folder to an Access 2000 DataBase field I have set up. I have not used Access in ages. The idea is is I will see the filename in one field,type in what it is for,see the next file name,type in what it is for etc. When I am done I will print the list out for the interested party
Name: Shane Date: September 18, 2003 at 03:17:16 Pacific
Reply:
I'm sure there are other ways to do this, but I would just use ACDSEE software (can be downloaded from zdnet etc). It's the same as explorer, but it has an option in the Tools menu bar of "generate file listing". This creates a nicely formatted text file of all the files in a folder, including any description you have already entered for it.
You can then just open this txt file in excel as delimited/fixed width etc, and the column headers (filename..Type..Size) are already there.
Then just do your access work to import the data.
0
Response Number 2
Name: johnshay Date: September 18, 2003 at 05:34:02 Pacific
Reply:
This might work:
use the dir command to output the folder contents to a text file.
in access, file -> get external data -> import
??
0
Response Number 3
Name: EK Date: September 18, 2003 at 05:52:55 Pacific
Summary: Hi I have a windows 2000 server and in it I have a folder in wich all users ca put files. The problem is that some users put movies in that folder, creating a space problem. I have too many users and...
Summary: Hi, I would like to do the following and I am totally lost right now: I have folder a) with lots of files I have folder b) which is empty I want to search all files in folder a) for a string "blablabl...
Summary: Hi, Probably the dumbest question on the face of the earth, but are there maximum numbers of files or folders that you can have in an ntfs partition? Thanks ...
0 
