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
Made with FlippingBook - Online magazine maker