Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
vlookup from Access db
Hey there,
I reckon the subject asks it all, but to explain further: I have barcodes in Excel in a column. Next to each I need to put a sales volume, which must be "vlooked"-up from an Access db. Is this possible? E.G. in Excel BarCode Volume 123456 20.00 (formula) In Access BarCode Volume 123456 20.00 Thank you for any help! |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
vlookup from Access db
If the Access table is not large then I would use Data External Data
New Database Query to bring the table into Excel from Access. (or equivalent; the naming has changed with different versions of Excel - it always helps us to help you if you specify) You can then do the VLOOKUP in Excel referencing the table. Alternatively, if you have a large table but only need a small number of lookups, you could make each lookup be a Query using the barcode as a parameter. Finally, if you have a very large table and quite a lot of lookups then it might be better to use a macro to navigate a recordset based on the Access table, and populate the Volume column. If you need help with your chosen route, come back Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
vlookup from Access db
Hi Bill, thank you for your response.
I have many sheets with many lookups to many access tables (all within a single db though), so I guess the last option would be best... can you possible elaborate a bit more on this? Thank you again! W "Bill Manville" wrote: If the Access table is not large then I would use Data External Data New Database Query to bring the table into Excel from Access. (or equivalent; the naming has changed with different versions of Excel - it always helps us to help you if you specify) You can then do the VLOOKUP in Excel referencing the table. Alternatively, if you have a large table but only need a small number of lookups, you could make each lookup be a Query using the barcode as a parameter. Finally, if you have a very large table and quite a lot of lookups then it might be better to use a macro to navigate a recordset based on the Access table, and populate the Volume column. If you need help with your chosen route, come back Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#4
Posted to microsoft.public.excel.links
|
|||
|
|||
vlookup from Access db
Many sheets with many lookups to many tables in a database suggests to
me that the design of your application may not be ideal for Excel, and I would hesitate to promote the recordset idea in this case. Try the QueryTable approach and see how you get on with it. Have you considered doing it all in Access? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP when referencing data from Access | Excel Worksheet Functions | |||
VLOOKUP with restricted access rights | Excel Worksheet Functions | |||
VLOOKUP from Access Tables | Excel Discussion (Misc queries) | |||
VLOOKUP from Access Tables | Excel Worksheet Functions | |||
vlookup and microsoft access | Excel Worksheet Functions |