Play Demo 

Are you a long-time user of Excel, with data that is growing in complexity or that changes frequently? Are you wasting time trying to remember where you have stored specific information, or are you entering the same information in multiple locations?

If so, consider importing your Excel data into an Access database. The Import Spreadsheet Wizard in Access makes it easy to copy the data from your Excel worksheets into a new or existing Access database. When you import the data, Access creates a copy of the data without altering the source Excel file. It’s a quick and efficient way of bringing different types of data together for analyzing, summarizing, and reporting.

How to do it (text version):

• Import, export, and link data between Access and Excel
• Creating a new Access database from an Excel spreadsheet

 Problems watching the video? Try our troubleshooting tips.