How to copy 4 tables from the same databse and paste in new table

[BizBoy]

H,

This might be silly question. Please excuse me for this.

I have 4 tables in my access file. I have created a blank table (5) in the same file.
Now I want to copy all 4 tables and paste in 5th table.
I am trying to do it manually but somehow I am not able to do it.

Can anyone please help me in this.

 

[Joe4]

Use an Append Query (or Queries) to write records from one Access table to another.
See: https://support.office.com/en-us/ar...nd-query-98a5bd66-2190-4243-9638-8ef649cf3596

 

[Micron]

Or use Paste Append. You can't just paste into an Access table like you do in other places.
If you have duplicate records between the tables, you may or may not end up with duplicates in the 5th table.

 

[BizBoy]

Hi Joe,

Thanks for the help. I am checking it and will revert with details.

Have a nice day ahead.

 

[BizBoy]

Hi Micron,

Thanks for the help. I am trying this. I am used to Excel hence by default, I end up using excel shortcuts.

Have a nice day ahead.