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]
Jumat, 02 September 2011
[MS_AccessPros] Compare, match and append rows in two tables
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar