Easily Import an Excel Spreadsheet into an Access Database with the help of the wizard

1. Click the External Data tab, then click the Excel command within the Import & Link group.

2. Click browse and go and navigate to your Excel file that you want to import.

3. Click on the spreadsheet you want.

4. Check yes to confirm that your data in Excel has headings in the first row.

5. Specify the data types for the fields. Tip- Zip codes should be text data types, not numbers.

6. Either let Access make up a new ID field which will be the primary key(unique values) or manually pick the field that you want to be the primary key.

7. Name the table and click finish.

External Data Tab Import Excel Spreadsheet

Select the Source of the Excel file

Which worksheet would you like

Does the first row contain headings

Specify data types for the import fields

Primary key selection

Name the Table and click Finish

After a few minutes of wizard time then your table is ready to go.

View the Data in the Access table


About Steve Chase

I'm a proud husband and dad to 4 boys! Microsoft Certified Trainer and Boy Scout Leader are some of things I call myself. The Cincinnati Reds are my favorite team! When not outdoors, I enjoy working with documents in Microsoft Office, QuickBooks, Visio and Photoshop. My wife, Erin, shares her awesome recipes on her blog at 5dollardinners.com.
This entry was posted in Access and tagged , . Bookmark the permalink.

One Response to Easily Import an Excel Spreadsheet into an Access Database with the help of the wizard

  1. Pingback: When Two Excel Spreadsheets Look the Same But Are Different…It’s Time For The Access Unmatched Query. | Steve Chase Docs

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s