vlookup from excel to access

[sal21]

assuming i have this code, is possible to use this vlookup withnthe adta
into mdb access?...

old scenario:
Private Sub TextBox25_Change()
Dim CODICE As Integer
Select Case Me.TextBox25
Case ""
Me.TextBox4 = ""
Case 1 To 8
CODICE = Val(Me.TextBox25)
Me.TextBox4 = Application.WorksheetFunction.VLookup _
(CODICE, Worksheets("TABELLA").Range("Q2:R9"), 2, False)
Case Else
Call MULTI_LINE_BOX
End Select
End Sub


new scenario:
Inested column Q and R in excel i have created a mdb into:

\\my server\myserverdir\USER.MDB

and into this mdb have inserte a table USER_NAME with:

Field1(with the same data of column R)
Field2(with the same data of column Q)

is possible now to make a vlookup?

EXAMPLE:
Filed1 Field2
OI14006 PPPPPPPPPP
OI15535 GGGGGGGGGGGG
OI15795 HHHHHHHHHHHHH
OI16135 HDSFDDFDFD
OI16696 DFFDFDFDSFD
OI16780 EREREWERERWER
OI16821 AAAADSDASDAD


+-------------------------------------------------------------------+
|Filename: USER.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4530 |
+-------------------------------------------------------------------+

 

[Tom Ogilvy]

No. Vlookup won't work with data resident in Access. If you used a query
table to bring it into Excel, then you could use vlookup against the returned
data.

 

[sal21]

No. Vlookup won't work with data resident in Access. If you used a
query
table to bring it into Excel, then you could use vlookup against the
returned
data.

ok Tom...
but your suggestion not for me...
help me please....

 

[Tom Ogilvy]

Maybe use ADO.

http://www.erlandsendata.no/english/index.php?t=envbadac

 

[Ron de Bruin]

See
http://www.rondebruin.nl/accessexcel.htm