Copy Paste Excel to Access - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Copy Paste Excel to Access

Qun Yu

5 years ago

Thanks to your tutorials I managed to create an inventory&sales ordering system for my small business.

Can I pick your brain on sth to improve which would make my life much easier?

For example, I have an order of 30 items on a excel order form. Instead of entering one by one, is there any way to copy&paste the whole lot of the product codes into the field, then copy&paste the qty, and the subform will do the rest? Looking forward to hear from you.

	Richard Rost @Reply 5 years ago
Very happy to help. Yes you can copy and paste the line items from Excel directly into Access IF your fields line up exactly the same. You may have to rearrange them in Excel. Once you do this, you shouldn't have any problems. One of my TechHelp Members actually asked a very similar question recently. I've got a video on it coming up soon.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View