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
