We do not advise you to copy data into your Access database
generally as it is better to ensure the data is in the correct format
and without errors by entering it in manually. However, should you wish
to copy data from Excel to Access, please:
- Highlight the cells within the rows that you wish to copy (note the amount of cells - it's best to do small amounts) and press CTRL C on your keyboard
- Navigate to Access and click on bottom corner of the first cell where you want your data to go and drag down down to highlight the amount of cells you have noted above.
- Then on your keyboard click CTRL V to paste your data.
