Question: You have imported Data from an Access Database into your Excel Workbook. The Query Editor window is visible on the right - hand side of

You have imported Data from an Access Database into your Excel Workbook. The Query Editor window is visible on the right-hand side of the Excel screen. Now that you have imported the data in your worksheet, you will only be working on it in Excel. Youre aware that colleagues amend the original data in Access regularly, but you do not need to see those changes in the Excel copy. What should you do to ensure that the data you have brought into Excel does not update when your Colleagues change the source?
1 point
In the Table Design Ribbon, click on the Refresh button and click on the delete link choice.
Click on the Delete Query button in the top left corner of the Query Editor window.
In the Table Design Ribbon, click on the Convert to Range choice in the Tools Group.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!