[AccessD] Another really dumb question

One quick little trick to bypass the linked table if you're going to run an
append query anyway, is from the design view of a query, right click on the
query window and click properties.  Find the Source Database property and
type the path and filename of the mdb you want to copy records from, then
when you go to choose tables to add to your query, the list will show tables
from the source database you specified.



-----Original Message-----
From: Gary Kjos [mailto:garykjos at gmail.com]
Sent: Wednesday, April 02, 2008 10:15 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Another really dumb question


Hi Barbara,

It depends on how many and how selective you need to be. You can copy
and paste individual records in table view. Or you can import an
entire table into another database using File/Get External
Data/Import. Or you can attach or link the table from the database you
want to copy from in the database you want to copy to and create an
append query into the table you want the records added to. that option
gives you the ability to select records that meet criteria as you
would do for a report or whatever.

GK

On Wed, Apr 2, 2008 at 9:57 AM, Barbara Mende <barbara at moosehill.com> wrote:
> How do I copy records from one Access database to another?
>
>  Thanks!
>  Barbara
>
>  --
>  AccessD mailing list
>  AccessD at databaseadvisors.com
>  http://databaseadvisors.com/mailman/listinfo/accessd
>  Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************