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

Groups > microsoft.public.excel.programming > #107988

Re: Lookup in Excel from Table in Access

Show all headers | View raw

> 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

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

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

csiph-web