My friend send me a bunch of files where it have a sql scripts for each table. I need to combine all those files into one and later will be use to reverse engineer and analyze the tables.
Below are simple steps that I use to combine all those files using command prompt.
Due to difference nature of work between me and my wife, I never had a chance to help her in her daily stuff related to her work and of course with my IT skills but for today, I’m happy to be able to help her.
She has a situation where she need to update her report based on the images files which is located in another PC. The files represent the matrix card which is already scan earlier and the filename is based on the matrix card number.
It’s pretty easy job as she need check the files and update her report if necessary.
What she did was, she open the folder, scan tru the images to compare the records and update it in Excel file . She also need to update the file’s modified date if it is exist.
Now, imagine what will happen if you are having a thousand files or more,it’s troublesome right ? doing the same thing all over again ?
At the moment I heard the situation, I know this problem can be solve easily with a help of VLOOKUP function in MS-Excel and a little bit DOS command added with a few more magic.
![[Ask]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/ask.png)
![[Bloglines]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/bloglines.png)
![[del.icio.us]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/digg.png)
![[Furl]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/furl.png)
![[StumbleUpon]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/technorati.png)
If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !
