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