Access to Excel

[tiab86]

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?

 

[Ron de Bruin]

hi tiab86

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

 

[Guest]

Also some help explaining how to use the MS Query tool here:

http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm