Lookup in Excel from Table in Access
 

I am working with data in both Excel and Access on a regular basis. I often need to do a quick lookup (i.e., essentially a Vlookup) in Excel, but the table that I am pulling from is in Access.

Is there a most efficient way that you would recommend to do this? I should probably note that when I am constantly pulling from one of three or four of the same tables in access (though the spreadsheet in Excel that I am pulling from is often just a random sheet that I happen to be working in).

One option is to import the Excel file into Access, and then to perform a query in Access the accomplishes the lookup, and then to export the results back out to Excel. This is a lot of steps and I am hoping there is a simpler, somewhat more efficient way to do this.

Thanks for any suggestions!

Lookup in Excel from Table in Access
 

I am working with data in both Excel and Access on a regular basis. I
often need to do a quick lookup (i.e., essentially a Vlookup) in
Excel, but the table that I am pulling from is in Access.

Is there a most efficient way that you would recommend to do this? I
should probably note that when I am constantly pulling from one of
three or four of the same tables in access (though the spreadsheet in
Excel that I am pulling from is often just a random sheet that I
happen to be working in).

One option is to import the Excel file into Access, and then to
perform a query in Access the accomplishes the lookup, and then to
export the results back out to Excel. This is a lot of steps and I am
hoping there is a simpler, somewhat more efficient way to do this.

Thanks for any suggestions!

Have a look at this...

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion