VLOOKUP from Access Tables

[Mraggie]

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???

[Miguel Zapico]

In that scenario I would recomend a database query with parameters. You may
find the help on how to create them in MS Query help, and how to input the
parameter in Excel in the Excel file, but basically is editing the SQL code
that the wizard generates in MS Query to add a condition comparing to a ?
sign.

Hope this helps,
Miguel.

"Mraggie" wrote:

>
> 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=570039
>
>

[feroguz]

Help about this thread please!!

[FDibbins]

would creating a link to the access file into excel work for you? then you could maniplulate the data as you need to

[arlu1201]

Feroguz,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.