Hi,

I got two files, one file consisting of 10000 records, with first
column starting from 1 and ending at 10000. the other file consists of
5000 records, with first column values changing ranging between 1 to
10000 (some of the values might miss in between). i need to search
both these files, match the values in the first column and write in
another file. is there any efficient way i can write a program in
visual basic ?

Thanking you,
Regards,
Ratnakar Pedagani

On 23 Aug 2004 08:39:02 -0700, EMAIL REMOVED (Ratnakar
Pedagani) wrote:

>Hi,
>
>I got two files, one file consisting of 10000 records, with first
>column starting from 1 and ending at 10000. the other file consists of
>5000 records, with first column values changing ranging between 1 to
>10000 (some of the values might miss in between). i need to search
>both these files, match the values in the first column and write in
>another file. is there any efficient way i can write a program in
>visual basic ?

Sort both files first
- sometimes making a third merge file and sorting that is the fastest