add data from one table into other table

's Computer Specifications

Hi,

how can we add reconrds from source table into destination table both in
same database without loosing the records of destination table.

Thanks!

's Computer Specifications

On Aug 18, 12:43*pm, Boss <B...@discussions.microsoft.com> wrote:
> Hi,
>
> how can we add reconrds from source table into destination table both in
> same database without loosing the records of destination table.
>
> Thanks!

use an append query.

's Computer Specifications

On Mon, 18 Aug 2008 10:43:04 -0700, Boss <(E-Mail Removed)>
wrote:

>Hi,
>
>how can we add reconrds from source table into destination table both in
>same database without loosing the records of destination table.
>
>Thanks!

Short answer: by running an Append query.

Long answer: I have no idea, since you don't describe your tables, their
primary keys, the nature of the data or the cause of your concern about losing
records.
--

John W. Vinson [MVP]

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert an untyped Data Table to a typed Data Table	John Wright	Microsoft VB .NET	6	14th May 2009 08:48 PM
Convert an untyped Data Table to a typed Data Table	John Wright	Microsoft VB .NET	0	14th May 2009 06:26 PM
Lookup data in a variable table & retrieve data from a pivot table	Shawna	Microsoft Excel Worksheet Functions	3	10th Oct 2008 11:11 PM
auto fill data into one table based on data from a linked table	=?Utf-8?B?RnJlaWRh?=	Microsoft Access Forms	5	5th Sep 2007 06:29 PM
Retain data in table based on changed data in another table	James	Microsoft Access Forms	3	14th Jan 2004 04:23 PM