Hi - I need a VB6 program that merges 3 text files vertically based on a primary key column-value in each file. The files are data.txt sheets exported to and from excel. One record goes across three files but some records do not exist in each of the three files. Those need to be taken out/deleted. I need to choose each file to merge via menu, I need a report on number of records to be deleted before I delete them to prevent erroneous mass deletions and I need to choose the new merged file name and save to that file. There seems to be a problem with empty cells in that merges offset the columns so its necessary to fill all of the empty cells before merge with filler data and then delete the filler data after merging. I can work with programmers and I can promise to have key data in certain places to facilitate ease of programming. I prefer the use of strings over the use of column is this VB6 program.
Good luck and happy bidding!