Show All

Change data in a queried database

1. In Microsoft Query, make sure the Allow Editing command is checked on the Records menu.

   In some instances, Microsoft Query will not allow you to change the data. If the Allow Editing command appears dimmed or Microsoft Query displays a message when you click the Allow Editing command, you can't change the data. For more information, click .

2. In the result set, click the field you want to change.
3. Change the information the way you want, and then press ENTER.

Note  If you make a mistake, you can reverse the most recent change by clicking Undo on the Edit menu. You must undo your change before you switch to another record or window.