Here Is What You Do:

• Open your access database and then open your excel file.
• Highlight your list data. Your list data should be Column formatted and have headings, typically.
• Then you hold the Control key and drag it to the database window.

Why Hold Control?:  Using Control while you drag produces a copy of the data.

Tip: Do not release the mouse button until you’re in the database window. If you see a circle with a slash, it won’t let you drop it there.

You can then write queries and reports off the newly created table.