I'm using Excel 2002 and querying excel files using ADO. I have read on the
microsoft site that there is a memory leak bug when you query open files, but
could not find any fixes for the problem. (Other than their suggestions of
effectively forming a duplicate copy of the data). Has anyone come up with a
sensible work around for the bug, or found an upgrade (maybe Excel 2003??)
that would help me?

Thanks.