Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 +-------------------------------------------------------------------+ |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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup from excel to access
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup from excel to access
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup from excel to access
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup from excel to access
See
http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl "sal21" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP used with Access DB inside of Excel Sheet | Excel Discussion (Misc queries) | |||
Vlookup problem with Access Query import into Excel 2000 | New Users to Excel | |||
Link cells in Access to Excel using VLOOKUP | Excel Discussion (Misc queries) | |||
VLookup to merge Access Query data into Excel Report | Excel Discussion (Misc queries) | |||
vlookup function in excel referencing an access table | Excel Worksheet Functions |