Export Access data to excel based on excel data lookup

[shalva.gelashvili]

I have table1 in Access2007 items as

col1 col2
text1 100
text2 150
text3 200
....... .....
textn 5000


also I have an excel file where i have the same text but not orginezed
in col(A)
A
1 text1
2 some other text
3 some other text
4 text2
5 text3
6 ......

and i need the col2 values to be exported from table1 to this excel sheet in next column

A B
1 text1 100
2 some other text
3 some other text
4 text2 150
5 text3 200
6 ......

example attached
Book1.zip

thank a lot

 

[nIGHTmAYOR]

http://www.access-programmers.co.uk/forums/showthread.php?t=156480