View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
PeteCresswell[_2_] PeteCresswell[_2_] is offline
external usenet poster
 
Posts: 56
Default Treating WorkSheet As MS Access Table?

On Jul 2, 9:24*am, "Patrick Molloy"
wrote:
sure - you can treat a sheet/named range as if were a database...
here's and example where every column is read from a table range named
Instruments (its on Sheet1)

in the development environment you need to set a Reference to Microsoft
Active Data Objects 2.6 Library * dll (or 2.7) * (menu: Tools/References)


That's exactly, *precisely* what I was hoping for.

Thanks.