Integrating Access into Excel

In MS Access:

1. Click "Edit" on the toolbar

2. Under "Edit" click "Select All Records" (The entire database will be highlighted)

3. Click "Edit" again on the toolbar

4. Under "Edit" click "Copy"

5. Open MS Excel

6. In Excel, make the first cell active

7. Click "Edit" on the toolbar

8. Under "Edit" click "Paste"

Now you are ready to use the Access data in Excel

Back To Help Page