How can I do a data lookup in excel using a datasheet in access?

's Computer Specifications

I have a large amount of data in access. There are more records than allowed
to paste into Excel. I am trying to us a lookup formula to find certain data
within these records. Is there a way to lookup the data directly from access
within excel? The data is also constantly changing depending user selections.

All help is greatly appreciated.

's Computer Specifications

Try this site: http://www.sqlexcel.net It is an add in to Excel to link to
any ODBC compliant database.

God Bless,

Mark A. Sam

"EVBH" <(E-Mail Removed)> wrote in message
news:05D8F8F6-6516-41F6-940D-(E-Mail Removed)...
>I have a large amount of data in access. There are more records than
>allowed
> to paste into Excel. I am trying to us a lookup formula to find certain
> data
> within these records. Is there a way to lookup the data directly from
> access
> within excel? The data is also constantly changing depending user
> selections.
>
> All help is greatly appreciated.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get datasheet row/column count and other datasheet informations	=?Utf-8?B?c2FuamF5X3NoYXJtYTc3?=	Microsoft Powerpoint	0	29th Aug 2007 06:38 AM
Form in datasheet view will not show my 2 subforms in datasheet vi	=?Utf-8?B?VGhlMm5kMDA3YmFiZQ==?=	Microsoft Access Forms	1	5th Mar 2007 08:41 PM
Lookup Lookup Lookup	=?Utf-8?B?TVI=?=	Microsoft Excel Worksheet Functions	2	10th Mar 2005 02:59 AM
"Lookup" Datasheet	JACKLE	Microsoft Access	0	29th Oct 2004 03:05 PM
datasheet: looping through records in a datasheet	Chris Large	Microsoft Access Forms	0	22nd Jul 2004 02:33 PM