I don't know the answer to your question, but I would always get data
from Access using Data Import External Data New Database Query

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup