Converting an Excel Spreadsheet to an Access 2007 Database

Next, you'll be presented with the screen shown above. Click the Browse button and navigate to the file you'd like to import. Once you've located the correct file, click the Open button.

On the bottom half of the screen, you're presented with import destination options. In this tutorial, we're interested in converting an existing Excel spreadsheet to a new Access database, so we'll choose "Import the source data into a new table in the current database."

Other options on this screen allow you to:

• Link your database to an Excel sheet so that changes in the source sheet are reflected in the database
• Import data into an existing database table

Once you've selected the correct file and option, click the OK button to continue.