vbnetcoder
asked on
Insert from one table to another
I want to insert the values of one table into another where there is a match on field names. There are some fields in both tables that are not the same they can be ignored
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you need to do this for a lot of table pairs or just once. If once, then Pat's solution is the simplest. Otherwise, you would need some VBA code that created the SQL based on the two table names.
ASKER
ty