found this that might work click here
TIP #10: BRING EXCEL DATA INTO ACCESS (Versions 7.0 & 97)
"""To bring data from a Microsoft Excel spreadsheet into Access, first open both programs and minimize Access.
Highlight the data in Excel that you want to import into Access. Point to the edge of the highlighted data, then ctrl/drag to the Taskbar and hold above the Access icon (DO NOT release the mouse button) until Access opens up.
Access will automatically import the data. """