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.
|