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

BizBoy

Board Regular
Joined
Jul 26, 2012
Messages
118
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.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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.
 
Upvote 0
Hi Joe,

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

Have a nice day ahead. :)
 
Upvote 0
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. :)
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top