sjercich
asked on
How to superimpose data from one Access table into another Access table
I would like to superimpose the data from one Access table over data in another Access table. For example,
Table A
A 0
B 0
C 0
D 0
Table B
B 6.7
C 3.7
Result after superposition
Table A
A 0
B 6.7
C 3.7
D 0
Can you tell me how to do this in Access?
Thank you,
Scott J
Table A
A 0
B 0
C 0
D 0
Table B
B 6.7
C 3.7
Result after superposition
Table A
A 0
B 6.7
C 3.7
D 0
Can you tell me how to do this in Access?
Thank you,
Scott J
mmconsultant
Can we assume that A, B, C and D are some field containing unique values?
An update query?
UPDATE TableA INNER JOIN TableB ON TableA.A = TableB.A SET TableA.A = [TableB].[A], TableA.B = [TableB].[B], TableA.C = [TableB].[C], TableA.D = [TableB].[D]
mx
UPDATE TableA INNER JOIN TableB ON TableA.A = TableB.A SET TableA.A = [TableB].[A], TableA.B = [TableB].[B], TableA.C = [TableB].[C], TableA.D = [TableB].[D]
mx
Not sure what you mean by 'superimpose'
mx
mx
ASKER
Yes... A, B, C and D are all unique values.
Thanks for the proposed solution. Can you tell me how to do it using Access without using SQL? I am not too familiar with SQL.
Thank you,
Scott J
Thanks for the proposed solution. Can you tell me how to do it using Access without using SQL? I am not too familiar with SQL.
Thank you,
Scott J
Actually, what I proposed probably won't work.
Is there a common field between Table A and Table B ... ie, they need to be 'joined' in some way. And again, what do you mean by superimpose ?
mx
Is there a common field between Table A and Table B ... ie, they need to be 'joined' in some way. And again, what do you mean by superimpose ?
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.