Microsoft Office Tutorials and References
In Depth Information
Text or spreadsheet data is easy to import into Access. In business, it is often necessary to import data
because companies use disparate systems. For example, assume that your healthcare coverage data is on the
human resources manager
s computer in a Microsoft Excel spreadsheet. Open the Excel application and then
create a spreadsheet using the data shown in Figure B-71.
Save the file and then close it. Now you can easily import the spreadsheet data into a new table in
Access. With your Employee database open, click the External Data tab, then click Excel in the Import &
Link group. Browse to find the Excel file you just created, and make sure the first radio button is selected to
import the source data into a new table in the current database (see Figure B-72). Click OK.
Importing Excel data into a new table