vlookup from excel to access

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

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.

--
Regards,
Tom Ogilvy


"sal21" wrote:

>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> sal21
>
>
> ------------------------------------------------------------------------
> sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
> View this thread: http://www.excelforum.com/showthread...hreadid=526768
>
>

Originally Posted by 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.

--
Regards,
Tom Ogilvy


"sal21" wrote:

>
> 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 |
> +-------------------------------------------------------------------+
>
> --
> sal21
>
>
> ------------------------------------------------------------------------
> sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
> View this thread: http://www.excelforum.com/showthread...hreadid=526768
>
>

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

Maybe use ADO.

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

--
Regards,
Tom Ogilvy


"sal21" wrote:

>
> Tom Ogilvy Wrote:
> > 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.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "sal21" wrote:
> >
> > >
> > > 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
> > |
> > >
> > +-------------------------------------------------------------------+
> > >
> > > --
> > > sal21
> > >
> > >
> > >
> > ------------------------------------------------------------------------
> > > sal21's Profile:
> > http://www.excelforum.com/member.php...fo&userid=2040
> > > View this thread:
> > http://www.excelforum.com/showthread...hreadid=526768
> > >
> > >
>
> ok Tom...
> but your suggestion not for me...
> help me please....
>
>
> --
> sal21
>
>
> ------------------------------------------------------------------------
> sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
> View this thread: http://www.excelforum.com/showthread...hreadid=526768
>
>

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"sal21" <sal21.25c7td_1143478203.3783@excelforum-nospam.com> wrote in message
news:sal21.25c7td_1143478203.3783@excelforum-nospam.com...
>
> Tom Ogilvy Wrote:
>> 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.
>>
>> --
>> Regards,
>> Tom Ogilvy
>>
>>
>> "sal21" wrote:
>>
>> >
>> > 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
>> |
>> >
>> +-------------------------------------------------------------------+
>> >
>> > --
>> > sal21
>> >
>> >
>> >
>> ------------------------------------------------------------------------
>> > sal21's Profile:
>> http://www.excelforum.com/member.php...fo&userid=2040
>> > View this thread:
>> http://www.excelforum.com/showthread...hreadid=526768
>> >
>> >
>
> ok Tom...
> but your suggestion not for me...
> help me please....
>
>
> --
> sal21
>
>
> ------------------------------------------------------------------------
> sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
> View this thread: http://www.excelforum.com/showthread...hreadid=526768
>