| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link cells in Access to Excel using VLOOKUP
I would like to link data in Access to cells in Excel using VLOOKUP. How
would this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link cells in Access to Excel using VLOOKUP
You can't point a VLOOKUP to Access. You'd have to write code or
use a query table to bring the data into Excel and uses that range in VLOOKUP. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dford" wrote in message ... I would like to link data in Access to cells in Excel using VLOOKUP. How would this be done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link cells in Access to Excel using VLOOKUP
The data I have in Access has about 130,000 lines of. Excel will only handle
65,000 lines. Is there any other way to do this? "Chip Pearson" wrote: You can't point a VLOOKUP to Access. You'd have to write code or use a query table to bring the data into Excel and uses that range in VLOOKUP. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dford" wrote in message ... I would like to link data in Access to cells in Excel using VLOOKUP. How would this be done? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link cells in Access to Excel using VLOOKUP
How many records (in Excel) do you want to perform this Vlookup-alike on? If it isn't very many then as Chip suggested a custom function could be written to achieve this. The problem that I have faced in the past when I have done this is that it is very slow - this restricts its usefulness to only a few records (of course, I may have just been writing the code inefficiently). Can you give an example of the kind of data the Access table holds, and what Excel is holding (and what you are doing with the data in Excel)? Richard -- RichardSchollar ------------------------------------------------------------------------ RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698 View this thread: http://www.excelforum.com/showthread...hreadid=546549 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link cells from one excel worksheet to another? | Excel Worksheet Functions | |||
| Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
| How do I link cells and keep the formating in excel? | Excel Discussion (Misc queries) | |||
| Trying to link MS Access to MS Excel | Links and Linking in Excel | |||
| vlookup function in excel referencing an access table | Excel Worksheet Functions | |||
Linear Mode
