Importing data

Resolved · Low Priority · Version 2007

Importing data

Malgorzata has attended:
Access Intermediate course
Access Advanced course

by - delegate Malgorzata [4 posts] (2008 Aug 18 Mon, 15:32) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	6	book now	£450	£485
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: importing data

by - trainer Stephen gold contributer [386 posts] (2008 Aug 19 Tue, 11:18) Reply

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

· Microsoft Access Tighten your Security Controls
· How to Find a Third-Party Venue for Microsoft Access Training
· Tips for designing databases in Microsoft Access
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course

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

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.