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

Advertisements

About Steve Chase

I want to help you work in your business, so you can work on your business. I want to help you achieve your goals and help you have a successful small business journey. I understand that keeping up with the latest technology and cloud based computer trends can be difficult, when you’re running your day to day business. But, it is crucial that you keep up with the technology and best understand your options, in order to thrive in this new era of online business. I can help you discover the right software and tools for your business, train your team on how to use them, and mentor you to best serve and delight your customers. My certifications include: QuickBooks ProAdvisor, Microsoft Office Specialist Master, and OntraPort Certified Consultant.
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