InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Solve : Extracting the date of a file into an excel file? |
| Answer» <html><body><p>Hi All,<br/><br/><br/><br/>I have a file called Myfile.mdl. This file is located in some <strong>D:\Folder_Name1\Folder_Name2\Myfile.mdl</strong>.<br/><br/>When we see the the details of this file We can <a href="https://interviewquestions.tuteehub.com/tag/find-11616" style="font-weight:bold;" target="_blank" title="Click to know more about FIND">FIND</a> out <strong><a href="https://interviewquestions.tuteehub.com/tag/nmae-2197082" style="font-weight:bold;" target="_blank" title="Click to know more about NMAE">NMAE</a>, Size, Type, <a href="https://interviewquestions.tuteehub.com/tag/date-11316" style="font-weight:bold;" target="_blank" title="Click to know more about DATE">DATE</a> Modified etc...</strong><br/><br/>I want to extract only that date into one Excel file called <strong>Myexcel.xls.</strong> And I want to send this date into the database table called Mytable into the column <strong>Success_date</strong>.<br/><br/>My database is <strong>Oracle.</strong><br/><br/>My table having the columns like <strong>Success_date, Failure_date.</strong><br/><br/>I need this <a href="https://interviewquestions.tuteehub.com/tag/urgently-2315680" style="font-weight:bold;" target="_blank" title="Click to know more about URGENTLY">URGENTLY</a>... anyone's help is most appriciated.<br/><br/><br/>Thanks & Regards<br/>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).<br/><br/>You might try VBScript where you can use the FileSystemObject (<a href="https://interviewquestions.tuteehub.com/tag/fso-458441" style="font-weight:bold;" target="_blank" title="Click to know more about FSO">FSO</a>) to get the date and use the ActiveX Data Object (ADO) to update both the Excel spreadsheet and the Oracle database.<br/><br/>This link will provide you with the <a href="http://www.connectionstrings.com/">connection strings</a> used by ADO to access the records in both Excel and Oracle.<br/><br/>Good luck.</p></body></html> | |