access+training+courses - Import data

The UK's most regular instructor-led training courses.
Training information: access+training+courses · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Import data

Lu has attended:
Access Introduction course

by - delegate Lu [3 posts] (2007 Feb 22 Thu, 14:44) Reply

How do i import data from other Access databases into a new table? At the moment when i do it it creates a new table rather than copying it into the one i want.

I am aiming to get data from numerous Access databases/tables into one new table...

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	7	book now	£345	£399
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Import data

by - trainer Orok bronze contributer [29 posts] (2007 Feb 22 Thu, 15:02) Reply

Hi Lu

I would suggest running an append query from your several source database(s) and appending the tables of interest to the destination database

Hope this helps

RE: Import data

by - delegate Lu [3 posts] (2007 Feb 22 Thu, 15:56) Reply

Hi

thanks for your suggestion, however i don't know how to run an append query!

RE: Import data

by - trainer Orok bronze contributer [29 posts] (2007 Feb 22 Thu, 16:21) Reply

Hi Lu,

On your Access Introduction course, you were introduced to Queries. These were examples of what are termed Select Queries. However, within the Query design view, Append Query can be selected from the Query menu option.

I would suggest attending the lintermediate course to learn about other query types. See link below

http://www.microsofttraining.net/access-courses-in-london-2003-intermediate.php

I have also provided an MS office resource that discusses the topic further.

http://office.microsoft.com/en-us/access/HA100765261033.aspx

Hope this helps

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps

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.

View all Access hints and tips

Institute of IT Training - Accredited Training Provider

Prodigy Platinum Learning Partner

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

access+training+courses - Import data

Related articles

Access tip:

Open A Combo Box Automatically