access+training+courses - import data

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+courses - Import data

access+training+courses - Import data

resolvedResolved · Low Priority · Version Standard

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

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


RE: Import data

Hi

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

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

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.07 secs.