try using dataImport External DataNew Database Query
then link to the query in the access db.
Should eliminate the problem steps you are experiencing.
--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread:
http://www.excelforum.com/showthread...hreadid=530854