excel tables, searching via sql interface?

  • Thread starter Thread starter cate
  • Start date Start date
C

cate

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

Thank you.
 
cate said:
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
Click to expand...
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.
 
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.
Click to expand...

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
 
Back
Top