Hi Sally
Another Bear in Space! Say hi to Liz for me.
You can join the two tables on the matching field. Create an append query with
the two tables joined and match up the fields putting source fields in the grid
and the target fields in the "Append To" line under the appropriate source
field.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com> http://thatlldoit.com
MS Access MVP
<http://mvp.support.microsoft.com/profile/Bill.Mosca>
http://mvp.support.microsoft.com/profile/Bill.Mosca
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Sally Vega
Sent: Friday, September 02, 2011 10:50 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Compare, match and append rows in two tables
Hi,
I'm new to VBA and new to this group. My co-worker Liz Ravenwood told me I'd get
great results if I posted my issue to this group!
This is what I'm trying to do. I have two tables in Access.
Table one is in this order:
Field2 Field4 Field5 Field7... up to 42 columns and over 1000 rows.
Table two is in this order:
Field1 Field2 Field3 Field4... etc.
In each table, th first row of each column has the word that needs to match. All
the column data that matches in table two needs to be appended to the matching
field in table one.
Can this be done in Access or is it more of an Excel issue?
Thank you.
Sally
This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar