Importing data

Resolved · Low Priority · Version 2007

Thu 24 Nov 2011, 14:26 Delegate Sarah said...

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

Fri 25 Nov 2011, 13:36 Trainer Simon said...

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.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.