Check out this site for example code Mike
http://www.erlandsendata.no/english/...php?t=envbadac

Post back if you got problems

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"mike" wrote in message ...
How could I write VBA code in Excel to get data from
Access.. is it possible to also have the code search the
first column of the Access database and return only a
particular field from the resulting search (and import
this into Excel)?

thanks