Hi All,



I have a file called Myfile.mdl. This file is located in some D:\Folder_Name1\Folder_Name2\Myfile.mdl.

When we see the the details of this file We can FIND out NMAE, Size, Type, DATE Modified etc...

I want to extract only that date into one Excel file called Myexcel.xls. And I want to send this date into the database table called Mytable into the column Success_date.

My database is Oracle.

My table having the columns like Success_date, Failure_date.

I need this URGENTLY...  anyone's help is most appriciated.


Thanks & Regards
SarayuYou can't do this with batch language. Batch code can process files at the file level (copy/move/delete etc) but only text files at the record level (create/update/delete etc).

You might try VBScript where you can use the FileSystemObject (FSO) to get the date and use the ActiveX Data Object (ADO) to update both the Excel spreadsheet and the Oracle database.

This link will provide you with the connection strings used by ADO to access the records in both Excel and Oracle.

Good luck.