View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mjones mjones is offline
external usenet poster
 
Posts: 86
Default Get data from Access file

HI All,

Is it possible to populate a cell from a cell (if that’s what it’s
called) in an Access file?

The access file is called qcpProg.mdb in a directory level one above
the excel file.

The data is in the tProduct table, UnitCost field (currency), with the
Product Code field (text) that is equal to Joseph4.

It would save me a lot of manual updates if I could do this.

Thanks!

Michele