Access Chapter 8

Demonstrable Skill	Learning Activities & Informal Assessments	Formal Assessments (excluding Exams)
Import data from Microsoft Excel workbooks.	MyLab Lesson C	MyLab Lesson C
Import data from CSV and text files.	Access: Database Creation Participation Project MyLab Lesson C	MyLab Lesson C
Export data to Microsoft Excel workbooks.	MyLab Lesson E	MyLab Lesson E
Share data with other Microsoft Access databases.	MyLab Lesson C	MyLab Lesson C
Export report data to other file formats.	MyLab Lesson E	MyLab Lesson E

Importing an Excel worksheet

If you have data in an Excel worksheet and wish to work on that data in Access, you can do so by importing the Excel worksheet into Access using the External Data ribbon [1].

Importing data from text files

There are two main types of text files that can be imported using the External Data ribbon [1]:

• CSV files, which use a comma to separate the values in each column.
• Fixed length TXT files, where each column is of a specific fixed length.

1. A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.