98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing data
Importing data
Resolved · Low Priority · Version 2007
Mon 18 Aug 2008, 15:32Delegate Malgorzata said...
Malgorzata has attended:
Access Intermediate course
Access Advanced course
Importing data
Since starting to work with Access 2007 I cannot just "copy" and "paste" data from excel directly into Access table even though the headers are exactly the same. Is this function not available in Access 2007?
Tue 19 Aug 2008, 11:18Trainer Stephen said...
RE: importing data
Hi malgorzata
Thank you for your question
I suggest using the paste append command. If you select the row that you need to copy, and click copy
Then open access and the table that is to receive the data. Then select the "Home" ribbon and select Paste append from the paste options button.
This seems to copy the data across as required
Regards
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
