cate said:
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