Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+courses - Import data
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access+training+courses - Import data
Resolved · Low Priority · Version Standard
Reply Thu 22 Feb 2007, 14:44Delegate 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...
For upcoming training course dates see: Pricing & availability
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
Reply Thu 22 Feb 2007, 15:56Delegate Lu said...
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
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
|