Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

importing data

ResolvedVersion 2007

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?

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 tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.