I have been able to correct the problem by placing the
reference table on the sheet that calls the macro (an open
table) the procedure now works perfectly.
Many thanks to all who have contributed
Jill
-----Original Message-----
[...]
Also, Andy Wiggins has a method using sql.request that
is supposed to
work
and if the data is in a table, it can be accessed using
ADO or
perhaps the
older DAO.

I believe Frank can post a reference to previous posts
on those
topics.

here we go:
http://tinyurl.com/2c62u

Frank

.