Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP from Access Tables
I need to do a VLOOKUP from a table in MSAccess. I want to use the same Access table to provide data to multiple spreadsheets. For instance, I have a client list that has client name and salesperson name linked to the client number. I need to pull both the client name and sales person by the client number in my Excel spreadsheets. The only place I have this data is in Access. Because the data in the Access table is live data, I don't want to repeatedly export that data into a spreadsheet to complete my VLOOKUP. Can anyone help??? -- Mraggie ------------------------------------------------------------------------ Mraggie's Profile: http://www.excelforum.com/member.php...o&userid=37290 View this thread: http://www.excelforum.com/showthread...hreadid=570090 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in pivot tables | Excel Worksheet Functions | |||
vlookup and microsoft access | Excel Worksheet Functions | |||
Linking Large Access Table into Excel | Links and Linking in Excel | |||
Excel to Access linked tables | Excel Discussion (Misc queries) | |||
How to compare two tables in Access 2000? | Excel Discussion (Misc queries) |