Merging Two Tables Together. Append Data

[raychow22]

Hi Forum,

I like to know if there a good way to appending my data together from different tables but have the same structure. The problem is that I have MVF which does not allow me to append the databases. I know that MVF is a programmer's nightmare and I've heard to never use it; however, for my applications the MVFs are helpful (I am not a programmer myself) and I do not want to eliminate them.

My solution would be to export these tables to excel and combine them there and import it back to Access.. it seems like a headache to do, but if anyone else got any suggestions, I would love to hear them. Thanks!!

[June7]

Nope, no 'good' way - if by 'good' you mean 'simple' - because of the MVF. Will require VBA code that manipulates parent and child recordset objects.

Not sure how exporting to Excel then back to Access will make dealing with MVFs any easier.

[raychow22]

Nope, no 'good' way - if by 'good' you mean 'simple' - because of the MVF. Will require VBA code that manipulates parent and child recordset objects.

Not sure how exporting to Excel then back to Access will make dealing with MVFs any easier.

You're right June7. Doing the export and import way eliminates the design of the tables which affects the forms. Do you know the VBA code to manipulate parent and child recordset objects?

[June7]

Bing: Access vba save data into multi value field
https://msdn.microsoft.com/en-us/lib...ffice.12).aspx
https://social.msdn.microsoft.com/Fo...orum=accessdev

However, I did find a way to insert values to MVF field of existing records using an INSERT query that pulls from another table MVF field. Review https://social.msdn.microsoft.com/Fo...orum=accessdev

So possibly you could run a query that adds new records with all fields except the MVF and then run a second SQL action to insert the MVF values.