You can "simply" use the EXCEL object model and control EXCEL remotedly from within ACCESS.
You can even store the spreadsheets inside the ACCESS table structure. I recently wrote a application for a consultant company in which stores up to 50 spreadsheets inside the "tblClients" table.