Link cells in Access to Excel using VLOOKUP

[dford]

I would like to link data in Access to cells in Excel using VLOOKUP. How
would this be done?

[Chip Pearson]

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" <[email protected]> wrote in message
news:[email protected]...
>I would like to link data in Access to cells in Excel using
>VLOOKUP. How
> would this be done?

[dford]

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" <[email protected]> wrote in message
> news:[email protected]...
> >I would like to link data in Access to cells in Excel using
> >VLOOKUP. How
> > would this be done?
>
>
>

[Richard Schollar]

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