cate wrote:
Is there a vba module that would allow one to search excel tables
as
if they were databases?

Have you used it? Some short feedback would be appreciated

Just be careful.

I do not know if it is already fixed, but there was a memory leak
when SQL query refereed to a table within the same excel file.
If data were stored in separate file it worked fine.

The link I posted shows how to use ADO to work with 'closed' Excel
files (and text files) as it would a normal database file. That
precludes, then, that the running code is not in the same file as the
data!<g (Nor should it be since the file containing the data isn't
open)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion