Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #107986 > unrolled thread

Lookup in Excel from Table in Access

Back to article view | Back to microsoft.public.excel.programming

Contents

  Lookup in Excel from Table in Access James <fred.sheriff@gmail.com> - 2015-08-20 14:38 -0700
    Re: Lookup in Excel from Table in Access GS <gs@v.invalid> - 2015-08-21 08:11 -0400

#107986 — 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!

[toc] | [next] | [standalone]

#107988

> 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/DatabaseProgramming.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

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web