I am creating a Excel packing slip that needs to pull information from
an Access table. Is there anyway to do this without pulling the whole
table from Access to Excel every time you want to ship something? So
basically is there any way to search an Access table as you would in a
VLOOKUP within Excel?


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=530947

hi tiab86

You can use the SQL string to retrieve the data you want
http://www.rondebruin.nl/accessexcel.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"tiab86" wrote in message
...

I am creating a Excel packing slip that needs to pull information from
an Access table. Is there anyway to do this without pulling the whole
table from Access to Excel every time you want to ship something? So
basically is there any way to search an Access table as you would in a
VLOOKUP within Excel?


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=530947

Also some help explaining how to use the MS Query tool he

http://www.nickhodge.co.uk/gui/datam...taexamples.htm


"tiab86" wrote:


I am creating a Excel packing slip that needs to pull information from
an Access table. Is there anyway to do this without pulling the whole
table from Access to Excel every time you want to ship something? So
basically is there any way to search an Access table as you would in a
VLOOKUP within Excel?


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=530947