Sometimes it is necessary to convert information that is being
stored in Microsoft Excel into a table in Microsoft Access. The process
is very simple, so just follow these steps:
First,
open the Access database that you want to
import the data into. If you do not already
have a database, you will need to create
one by loading Access, then telling it you
want to create a new blank database.
Click on
the File menu.
Go to Get
External Data.
Click Import.
The file
open dialog box will now come up. Browse
to where you have your Excel Spreadsheet
saved.
At the
bottom of the window, change the Files of
type from Microsoft Access to Microsoft Excel.
Select
the file that you want to import the data
from, and then click on Import.
If your
data is on a sheet other than the default
of Sheet1, change it here, otherwise, click
next.
If the
first row of your data contains headings,
click the checkbox at the top of the window.
Now click Next again.
Unless
you want to insert the data into an existing
table, click Next.
Unless
you want to change the way that the fields
are named, etc., click Next again. If you
have any extra columns (other than Last,
Middle, First, Address, Address2, Address3,
City, State, and Zip,) now would be a good
time to not import the data from them. To
do this, simply click at the top of the column
(where its name is at) and then check the
box named Do not import field (skip) for
each extra column.
In many
cases, you will want to define a primary
key, but if you are submitting the database
for label printing to University Services,
click the button labeled No primary key,
then click Next.
If you
want to give the table a specific name, enter
it here, then click on Finish.
