Access 2016 Advanced

Access 2016

Lesson 7 – Exporting Data

When you drag and drop data to Excel, any formatting applied to the data in Access will be lost in Excel. However, the field headings in Access are preserved in Excel.

Drag and drop data into Excel



Procedures

1. Open Microsoft Excel. 2. Open the workbook. 3. Open the database in Access. 4. Display the object list. 5. Select the Access data source you want to drag into Excel. 6. Drag the data source to the desired location in the Excel workbook.



Step-by-Step

Drag and drop data into Excel.

If necessary, display All Access Objects in the Navigation Pane.

Open a blank workbook in Excel and resize the Excel and Access windows so that they appear side by side.

OFFICEPRO, Inc.

Page 81