add data from one table into other table

  • Thread starter Thread starter Boss
  • Start date Start date
B

Boss

Hi,

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

Thanks!
 
Hi,

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

Thanks!
Click to expand...

use an append query.
 
Hi,

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

Thanks!
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
VBA - retrieve data on last create named range from previous inserted named range 0
How to export table from outlook into ms access table? 0
How to Populate Data from a table to another 0
show number of records updated 2
Clear Data in Table, then Import from Excel SS 2
RE: Insert Into with Where Clause 10
Copy data from one databse tabel to other database table 1

Back
Top