merge 2 files

[reza]

Dear All,

need ur help again.
I have 2 file with different tables.
for File A, i have customer Id, name
for File B, i have customer Id, Address.
now i want to merge 2 file become one.
i want to insert address field automatically to file A and parameter
customer Id file A = customer Id file B.
can you teach me how to achieve that....

thanks


reza

 

[Alex]

You can use function"VLOOKUP" to achieve.
In file A, input Address, then use formula
=vlookup(A2,fileB.xls!A:B,2,0), suppose your customer ID are in column A in
both file A and file B, Name and address are in column B.
Hope this can be of help.

 

[reza]

thanks alex....

You can use function"VLOOKUP" to achieve.
In file A, input Address, then use formula
=vlookup(A2,fileB.xls!A:B,2,0), suppose your customer ID are in column A in
both file A and file B, Name and address are in column B.
Hope this can be of help.

 

[Reno Gajo]

Hi Reza,

There is a new PC software that you can use as a supplement to Microsoft Excel and Access. For one thing, it combines multiple files. Visit www.genresoftware.com and look at the pages Importing Files and Programming Instruction Set.

Cheers,
Reno



reza wrote:

merge 2 files
25-Jan-10

Dear All

need ur help again
I have 2 file with different tables
for File A, i have customer Id, nam
for File B, i have customer Id, Address
now i want to merge 2 file become one
i want to insert address field automatically to file A and paramete
customer Id file A = customer Id file B
can you teach me how to achieve that...

thank

reza

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
C# .NET Windows Task Scheduler
http://www.eggheadcafe.com/tutorial...d48-8fbd2ed2ed88/c-net-windows-task-sche.aspx