Archived files to be exported to excel

Pradeepmenon · Mar 14, 2013

HI,
An archived is been created on every day basis in its own name eg:20130314 or 20130313 like that, and on every archived folder there are many data. I need to export those data, only the name of the file and the modified date to an excel. Could any one please help me out to write a code for that, or can i do in some other form too???

_kaos_ · Mar 14, 2013

I don't know of any program that will do this...
But I know of a cmd command that can achieve the same

Open cmd
Navigate to the particular folder where the files are stored using the cd command
Use the following command at the cmd prompt

dir /o:n /s /t:w > tmp.txt

This will create a text file named tmp in that directory, containing names as well as date & time (the file/folder was written i.e modified), of all the files/folders/subfolders...
You can then copy that data to an excel sheet.

Pradeepmenon · Mar 14, 2013

hi,
The server is a production server, and every time its not posssible to login to the server and run the CMD promt.There are many people who do login to ther server and if any one does any thing wrong, then its gonna be a huge mess.
and as its a archived folder which gets update on daily basis, its better to script that out. Please help me out in that.

Search

Archived files to be exported to excel

Pradeepmenon

Honorable

_kaos_

Honorable

Pradeepmenon

Honorable

TRENDING THREADS

Latest posts

Moderators online

Share this page