-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do I copy a record from one table to another?
- Thread starter NYcowgirl
- Start date
james_lankford
Well-known Member
- Joined
- Jan 11, 2009
- Messages
- 1,222
Code:
INSERT INTO
Table_2
(
col_1,
col_2,
col_3
)
SELECT
Table_1.col_1,
Table_1.col_2,
Table_1.col_3
FROM
Table_1
WHERE
(
(
Table1.id = 1
)
)of course change the id to whatever the id is of the row you are copying
Upvote
0
james_lankford
Well-known Member
- Joined
- Jan 11, 2009
- Messages
- 1,222
I don't have 2007; I have 2003, but I guess it should be similar
open the table you want to copy from and the table you want to copy to
going down the left side of both tables is a light blue or light gray column
in access 2003 there is a little pencil in this column when you edit a row
so on the table you want to copy from, right mouse click in that blue/gray column on the row that you want to copy
a little pop up menu pops up
on the pop up menu it says New, Delete, Cut, Copy, Paste
select Copy
then go to the table you want to copy to
right mouse click on blue/gray on the last row of that table, its the row where you normally type in your new record, the one with the * next to it
so you right mouse click on the * and the pop up menu pops up, then you select Paste
and that should do it
assuming the columns in both tables are the same type and in the same order
open the table you want to copy from and the table you want to copy to
going down the left side of both tables is a light blue or light gray column
in access 2003 there is a little pencil in this column when you edit a row
so on the table you want to copy from, right mouse click in that blue/gray column on the row that you want to copy
a little pop up menu pops up
on the pop up menu it says New, Delete, Cut, Copy, Paste
select Copy
then go to the table you want to copy to
right mouse click on blue/gray on the last row of that table, its the row where you normally type in your new record, the one with the * next to it
so you right mouse click on the * and the pop up menu pops up, then you select Paste
and that should do it
assuming the columns in both tables are the same type and in the same order
Last edited:
Upvote
0
james_lankford
Well-known Member
- Joined
- Jan 11, 2009
- Messages
- 1,222
here's a video that shows copying a record to the SAME table,
and it shows it just as I described and just as you have tried
I assume it would be the same for copying to a different table, I don't know why it doesn't work
oh, and the video took a long time to open for me
http://www.bestechvideos.com/2008/11/14/techtutor-tv-copy-a-record-in-access-2007
and it shows it just as I described and just as you have tried
I assume it would be the same for copying to a different table, I don't know why it doesn't work
oh, and the video took a long time to open for me
http://www.bestechvideos.com/2008/11/14/techtutor-tv-copy-a-record-in-access-2007
Upvote
0
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
Carin
I'll ask again, why?
If you, as it appears, tables with identical structure then that suggests that the structure of your database isn't normalized.
If you do have a normalized database it's far easier to work with and maintain.
I'll ask again, why?
If you, as it appears, tables with identical structure then that suggests that the structure of your database isn't normalized.
If you do have a normalized database it's far easier to work with and maintain.
Upvote
0
Similar threads
