read from excel files

[manojmanmathan]

I wish to know how can I do the following, mostly in TC ( i had studied TC long back but seldom used it)
I have two excel files. File1 has a lot of rows in order of 15000nos, each row containing names etc. Excel File2 has some rows in order of 200's, containing names etc. File1 name field has to be searched for occurance of each name given in File2-name field. if found, the corresponding record in File1 has to be deleted.

thanks and regards
Manoj

[Computergeek01]

This is like trying to pound a screw in with a hammer. It is physically possible and C++ could accomplish the job but it is not the right tool. I always suggest using VBS for dealing with Excel files.

[zlatan24]

Determine for given complicated question there is a http://www.recoverytoolbox.com/excel.html The software can work under low system requirements. It doesn't modify source excel files during recovering. The application scans and analyses damaged data after restore info and can show the results of working with problem excel data.