Thanks! Question answered

Ilmater

Diamond Member
Jun 13, 2002
7,516
1
0
I have two tables in Access that are just lists of the same thing. I need them in one table. How do I do it?

EDIT: Answered... thanks Mikey!
 

Ilmater

Diamond Member
Jun 13, 2002
7,516
1
0
Originally posted by: MikeyIs4Dcats
just cut and paste from on into the other IIRC
Oh yeah.

Wow.

They really should fire me. Sometimes... I just don't know.
 

junkerman123

Golden Member
Jul 4, 2003
1,935
0
0
cut and paste ought to work, if not there is a merge tables function, but dangnabbit if i remember how to use it, just poker around a bit.
 

dugweb

Diamond Member
Oct 17, 2002
3,935
1
81
did you at least try the software forum first? that's kinda a prerequisite to posting a question of this nature in OT
 
Nov 5, 2001
18,366
3
0
Originally posted by: Ilmater
Originally posted by: MikeyIs4Dcats
just cut and paste from on into the other IIRC
Oh yeah.

Wow.

They really should fire me. Sometimes... I just don't know.


It's bee a couple of years since I messed with it really, but I think that will work.
 

Ilmater

Diamond Member
Jun 13, 2002
7,516
1
0
Originally posted by: MikeyIs4Dcats
It's bee a couple of years since I messed with it really, but I think that will work.
It did work. I already did it. ;)
 

DBL

Platinum Member
Mar 23, 2001
2,637
0
0
If the structure is exactly the same, you can just cut and paste, otherwise create an append query.