The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing data

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Importing data

Resolved · Low Priority · Version 2007

ReplyMon 18 Aug 2008, 15:32Delegate Malgorzata said...

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?

For upcoming training course dates see: Pricing & availability

ReplyTue 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

Access articles

· How To Create Calculated Fields In Access 2010 Tables
· Microsoft Access Courses
· Bring Access Up To Speed
· How To Use Tabs To Show Lots Of Related Data On One Form In Access
· Build International Databases With Microsoft Access

Please browse our web site to find out more about
access course london and other Microsoft training courses.

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes

Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips

Is there a simple way of moving a task to a different place in a task list which does not require using the priority function?

» Forum post: Tasks

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions