Greenwood School District 50
Microsoft Office 97
Skills and Competencies

File Sharing

Microsoft Office 97 provides the tools to move information back and forth between the different Office applications. For example, you can move a Word 97 table into Excel (as a worksheet) or into Access (as a database file). The following steps describe the process of moving/copying information among Word 97, Excel 97, and Access 97:

Word Documents (tables)
To Move a Word Table into Excel
Highlight the entire table
Edit/Copy
Open Excel and place your cursor
Edit/Paste
Save the Excel worksheet

To Move a Word Table into Access
Move the table into Excel, as described above
Save the Excel worksheet and close it
Open Access
Choose file type equal Excel
Find and open the Excel file
Answer the questions about the file and give it a name
Save the Access database file

Excel Worksheets
To Move an Excel Worksheet to Word
Open Word
File/Open
Change file type to Excel worksheet
Find and open the file, which comes in as a table
Save the Word document

To Move an Excel worksheet into Access
Open Access
Choose file type equal Excel and open file
Answer the questions about the file
Save the Access database file

Access Database Files (Tables)
To Move an Access table to Excel
Open the Access table
File/Save As/Export
Choose file type equal Excel
Export and name file
Open Excel
Open exported file in Excel
Save Excel worksheet

To Move an Access table to Word
Complete the steps above through export and name file (move Access table to Excel)
Open Word
File/Open
File type equal Excel
Open file
Save Word document