How do I copy data from Excel into the correct field in Access

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.

Be sure to save your work and follow the database tips and rules on your admin page and in the help menu.