When you export data, you save an open document in a new format so that it can be opened in an entirely different program. When you import data, you insert a copy of a file (from the same or another program) into an open document. For example, you might import an Excel worksheet into a Word document to create a one-page report with text and a table. Or you might want to export part of an Excel worksheet to use in another program. Export a File to Another Program -
| Click the File menu, and then click Save As. | -
| If necessary, click the Save In list arrow, and then select the drive and folder where you want to save the file. | -
| Click the Save As Type list arrow, and then select the type of file you want. | -
| If necessary, type a new name for the file. | -
| Click Save. | -
| Edit the file from within the new program. | Did You Know? You can use copy and paste to export information . If you want to move only part of a file into your document, just copy the information you want to insert, and then paste the information in the file where you want it to appear. You can import part of a file into Word . You can insert into a Word document a bookmarked section of a Word document or a specific range in an Excel worksheet. Click Range in the Insert File dialog box, enter a bookmark name or range, and then click OK. | Import a File -
| Click where you want to insert the imported file. | -
| Do one of the following: | -
In Word, click the Insert menu, and then click File. -
In Excel, click the Data menu, point to Import External Data, and then click Import Data. -
In PowerPoint, click the Insert menu, click Slides From File, and then click Browse. -
In Access, click the File menu, point to Get External Data, and then click Import. -
In Publisher, click the Insert menu, and then click Insert Text. -
| Click the Files Of Type list arrow, and then click All Files. | -
| Select the drive and folder of the file you want to import. | -
| Double-click the name of the file you want to import. | -
In PowerPoint, click Display, click the slides you want to import, click Insert, and then click Close. In Access, follow the Import Spreadsheet Wizard instructions to set up the Excel data as an Access table. Did You Know? You can link a file in Word . If you start to import a file into Word, you can link it instead. Click the Insert menu, click Insert File, select the file to link, click the Insert list arrow, and then click Insert As Link. | |