Microsoft Office Tutorials and References
In Depth Information
Importing data from a Microsoft Excel spreadsheet
2
Right-click the ID i eld and select Primary Key.
Selecting the Primary Key.
3
Right-click the table’s tab and choose Save. Type Roster in the Table Name text i eld in
the Save As dialog box and press OK.
At this point, you can enter data into the table cells by typing, copying and pasting, or
importing.
Importing data from a Microsoft Excel spreadsheet
While spreadsheets can store data, databases are more powerful, expandable, and often easier
when managing large amounts of data. You can import data from external sources such as
text i les, XML i les, other database types, and spreadsheets into your Access 2010 databases.
Here you will use the Import Spreadsheet Wizard to import data from an Excel spreadsheet
into an Access table.
To import data from Excel:
1
Open the program Excel and choose File > Open. Navigate to the Access02lessons
folder and double-click SB Roster to open the spreadsheet. The spreadsheet contains the
following information:
ID
POSITION
BATS
THROWS
AVG
22
1st base
Right
Right
700
13
pitcher
Right
Left
250
23
2nd base
Right
Right
444
42
Left field
Switch
Left
333
8
Center field
Switch
Left
500
4
Catcher
Left
Switch
333
9
pitcher
Left
Left
198
2
Switch back to Access where your SCRATCH database is still active by clicking on the
Access icon found on the Task Bar along the bottom of your screen.
3
In the Roster table select the External Data tab and click Excel located in the Import &
Link group.
4
In the Get External Data window, browse to the Excel i le and click Open so that it
appears in the File name text i eld.
Search JabSto ::




Custom Search