excel tables, searching via sql interface?

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

 

[GS]

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.

ADODB does this. Here's a good place to start...

http://www.appspro.com/conference/DatabaseProgramming.zip

--
Garry

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

 

[witek]

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.

 

[GS]

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