|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com