Computing
Databases
Search
Databases
Database Basics
Learning SQL
Using Databases
Share
Converting an Excel Spreadsheet to an Access 2010 Database
By
Mike Chapple
, About.com Guide
8 of 9
Previous
Next
Name Your Table
Mike Chapple
You need to provide Access with a name to reference your table. We'll call our table "Contacts." Enter this into the appropriate field and click on the Finish button.
Previous
Prepare Your Data
Create a New Access 2010 Database
Begin the Excel Import Process
Select the Source and Destination
Select Column Headings
Create Any Desired Indexes
Select a Primary Key
Name Your Table
View Your Data
Next
Suggested Reading
Microsoft Access Resources
Microsoft Access Tutorials
Time-Saving Tips for Microsoft Access 2010
Suggested Reading
Exporting Data from Microsoft Access 2010 to Microsoft Excel
Converting an Access Database to SQL Server
Backing up an Access 2010 Database
Suggested Reading
How to Convert a Database to Access 2010 Format
Password Protecting an Access 2010 Database
How to Change the Default Database Format in Access 2010
Related Articles
Background - Pool and Billiards
Traditional Wedding Gifts - Father of the Bride
Countries and Nationalities - German
Mike Chapple
Databases Guide
Sign up
for My Newsletter
Headlines
Forum
See More About
access tutorials
database tutorials
microsoft excel
microsoft office
microsoft access
Explore Databases
Must Reads
Databases for Beginners
SQL Basics
Top 10 SQL FAQs
Top 5 Things Beginners Need to Know
Database Glossary
Most Popular
Database Normalization Basics
Primary Key
SQL Server 2012 Editions
What is a Database?
First Normal Form
By Category
Microsoft Access
Learning SQL
SQL Server
Oracle
Security in Databases
MySQL
Administration
Design
Development
Data Mining
Database Training
Careers
Reviews
Certifications
Other Databases
Databases
About.com
Computing
Databases
Microsoft Access
Tutorials
Name Your Table
Advertise on About.com
Our Story
News & Events
SiteMap
All Topics
Reprints
Help
Write for About
Careers at About
User Agreement
Ethics Policy
Patent Info.
Privacy Policy
Your Ad Choices
©2013 About.com. All rights reserved.