Does anyone know how i can generate a database of all the files in a group of folders on my machine.
I want to create a query in Excel which imports all the files in a particular folder/subfolders. Each filename becomes a row in the spreadsheet and each row has the following data as individual fields/columns:
filename
date created
file type
subfolder name
file attribute a
file attribute b
etc
The result would almost mirror Windows Explorer but the data would be in a spreadsheet and could therefore be manipulated and the query could be refreshed.
Any help much appreciated
Jacck
I want to create a query in Excel which imports all the files in a particular folder/subfolders. Each filename becomes a row in the spreadsheet and each row has the following data as individual fields/columns:
filename
date created
file type
subfolder name
file attribute a
file attribute b
etc
The result would almost mirror Windows Explorer but the data would be in a spreadsheet and could therefore be manipulated and the query could be refreshed.
Any help much appreciated
Jacck