Shopping Cart
Your basket is empty

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

 by demo on 11 Jun 2010 |
No Comment

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.


Leave a comment

* Please enter your name.
Email address will not be published
Please enter a valid email address.
* Please enter your comment.
Image Verification
'Please enter security code.
New Products
onda v812
EU €172.97
EU €160.15
CamelBak Alpine Explorer Hydration Pack - 100 fl. oz
EU €76.87
EU €51.25