In Access you can have an Excel sheet as a linked table (provided of
course that it has a columnar table structure like an Access table).

File / Get External Data / (Excel files) / Your file / Link

Then you can use it in Access as if it were an Access table.

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