Excel Lookup to Access Database

[uhu]

Hi everyone,

I am trying to create a small vba program in Excel that allows me to do automatic lookup from Access Database.
Example:

Col A Col B Col C
1
2
3
4

I want Col B and C to be automatically filled with data fom a table in Access database, with Col A 's data used as the linker.
What's the best way of doing it ?
Is there any documentation/webpage/examples I can refer to?

Thanks in advance

vito

 

[SkipVought]

Hi,

Pretty simple -- just use menu item

Data/Get external data

and set up a query to the database/table you want to list, and....

VOLA!


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[uhu]

thanks

but, I found that i can create a custom function, which also works fine.