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.

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

Good samples:
www.erlandsendata.no

Good reference on all ado objects and methods:
http://www.devguru.com/Technologies/...ado_intro.html

lot's of documentation on connection strings:
http://www.able-consulting.com/ADO_Conn.htm


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"?B?TUs=?=" wrote:

Have done some VBA/Access work, new to VBA/Excel

Would like to run queries (SQL) using Excel ranges and return the
results to a new spreadsheet. Are there any pitfalls I should be
aware of before I get started ?

Thanks,
Mike

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.

--