excel tables, searching via sql interface?

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

witek

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

GS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top