Maybe I’ve missed the boat on this one but I never knew you could open an Access table directly inside excel, I’ve always exported them to .xls files in Access, or used Get Extrenal Data. In Excel, file open (pick all from the type drop down) and click on the Access DB, give you this:

Cliciking the table will import it into excel – i guess it errors out when you go over 65537!