access+training+courses - Import data

Resolved · Low Priority · Version Standard

Thu 22 Feb 2007, 14:44 Delegate Lu said...

Lu has attended:
Access Introduction course

Import data

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

Thu 22 Feb 2007, 15:02 Trainer Orok said...

RE: Import data

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

Thu 22 Feb 2007, 15:56 Delegate Lu said...

RE: Import data

Hi

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

Thu 22 Feb 2007, 16:21 Trainer Orok said...

RE: Import data

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

https://www.stl-training.co.uk/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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips