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

importing data

ResolvedVersion 2007

Sarah has attended:
Access Introduction course

Importing data

Hi,

Please can you tell me is it possible to import information from an Access 2000 database into Access 2007 and if so how?

Thank you

Sarah

RE: Importing data

Hi Sarah,

Thank you for your question and welcome to the forum.

This should be possible. Go to the External Data tab on the ribbon and click the Access button on the Import group.

Click Browse and select the database you want to import the data from and then select which object you want imported.

Then click Finish on the Wizard.

I hope this answers your question.


Regards

Simon

Thu 1 Dec 2011: Automatically marked as resolved.

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

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.15 secs.