AB formulated on Friday :
Also, the connection provided you use DOES NOT depend on which Excel
version you use but depends on which Access database version you use -
eitehr .mdb or .accdb - then providers are different.

Thanks for making this correction! My bad for not specifying the db
source...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc