0

Hi ...
I am totally new to vb programming.I have to do something like this for this i am not having any idea,kindly help me.

I have two excel files--
file one has data like thi---

601A 600 580 780 48 300 33
601B 600 580 780 48 300
601C 600 580 780 54 300 33
601D 560 580 780 48 300 33
603A 600 580 780 48 300 33
603B 600 580 780 48 300
603C 600 580 780 54 300 33
603D 560 580 780 48 300 33
614A 600 580 780 48 300 33
614B 600 580 780 48 300
614C 600 580 780 54 300 33
614D 560 580 780 48 300 33
615A 600 580 780 48 300 33
615B 600 580 780 48 300
615C 600 580 780 54 300 33
615D 560 580 780 48 300 33
There are so many values like this---

file 2 has---
601A PT UAD_FLG A1 33
601A PT UAD_FLG A2 33
601A PT UAD_FLG A3 34
601A PT TEST_FLG 1 50
601A PT TEST_FLG 2 50
601A PT BTMOD_FLG 5 10
601A PT BTMOD_FLG 6 10
601A PT BTMOD_FLG 7 80
601B PT TEST_FLG 1 50
601B PT TEST_FLG 2 50
601B PT BTMOD_FLG 5 10
601B PT BTMOD_FLG 6 10
601B PT BTMOD_FLG 7 80
601C PT UAD_FLG A1 33
601C PT UAD_FLG A2 33
601C PT UAD_FLG A3 34
601C PT TEST_FLG 1 50
601C PT TEST_FLG 2 50
601C PT BTMOD_FLG 5 10
601C PT BTMOD_FLG 6 10
601C PT BTMOD_FLG 7 80
601D PT UAD_FLG A1 33
There are so many values like this.

My requirement is----

from file one i have to compare the fields like 601A ,603A and so on..........of file 1 and file 2 and take values corresponding to 601A .......... of file 2 for second column.If you have any concers i will try to clarify that.any logic for this.
Any logic for this or a code will be a great help.

Thanks in advance.
Namish

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by Mikepf
0

If this is NOT in Access, then you need training. Also, are you comparing the first column (first 4 characters) in the first file to the first column (first 4 characters) in the second file? If yes to both:
1. Import both Excel files to tables (A and B).
2. In TOOLS, RELATIONSHIP, add both TableA and TableB to the window then drag the first column of TableA to the first column of TableB. Save the relationship.
2. In Design Wizard:
a. Select TableA then TableB
3. In the design mode, select all needed columns from both tables to create the results. *

*This assumes that you won't get data returned unless TableA matches TableB

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.