keepITcool wrote ...

The only real pitfall is that the workbooks from which you read data
should be closed. if they are open, this leads to memory leaks and
crashes.

The workaround for this bug is simple: save the source worksheets to a
new workbook, save and close it, then query the closed workbook.

I'd say there was another common pitfall: the 'mixed data types'
scenario:

http://www.dicks-blog.com/excel/2004...al_data_m.html

There are several good sites for learning to work with excel and ADO

I don't think any of those links discuss the memory leak bug or give
an example of the workaround, so try this one:

http://groups.google.com/groups?selm...g .google.com

Jamie.

--