Importing File Tree

[zanestoy]

I am looking at importing a file tree into an access database. I want it to update with the file tree, as new files are added. The full scale scope of this will be to have all of my digital files in the final database so they can be easily looked up by keyword or title, along with my hard copies of meeting notes, etc. Does this make sense?
Thanks

[ajetrumpet]

no it doesnt, actually!

what's a file tree??

[alansidman]

Is this what you are referring to?

http://www.datapigtechnologies.com/f...viewmaker.html

Alan

[zanestoy]

The tree view video is close to what I am looking for. However, I want Access to look at a folder on my hard drive, and then make a table out of all of the files in that folder. Any folders that are in the first folder, would then lead to another table which would have it's files in it.

Thanks for any help.

[ajetrumpet]

that is easy to do sir, with the help of this page: http://allenbrowne.com/ser-59.html

the rest of the code is easy vba.

but why are you doing it?? that's the question. Rarely have I seen anyone ask something like this. Care to share??

[zanestoy]

Thanks this is exactly what I am looking for. I am a graduate student in engineering and have a lot of files for all of my classes. I also have a lot of hard copies of various notes from my classes. I am building a database of hard copies and digital copies of all of my stuff so it is easily searchable and I am able to quickly find a reference.

Thanks for the help.