Search results

1. Write a Delete action query to clean up the table. 2. You will need to Actions in the macro. 3. First action, "open query", the below choose your delete query. That will run it and delete the data in the table. 4. Next you might want to do an Import spec on your Excel sheet and save it then...

If you have relationships it may cause a problem. Why not do a Delete query to clean out the original table and then Import to the real table. Do a macro to do the 2 steps and all is good. PatM-Reno, NV USA

Thanks to all this has been super helpful. PatM-Reno

Yes, banana, I do understand but still not quite sure " the why" to use it. And I do understand the Outer Join would not do it now, thanks. Pat

Thanks Banana and Bob again, Little more clear now. I understand the concept much better now. I like the example of an archive table and current table using UNION to find the differences. An outer join would do the same I think. Thanks again folks. I am going to like this forum. Pat

Thanks Bob. Can you give me an example and why you would use UNION? I do understand the FULL JOIN idea but seldom need it. I'm doing an online T-SQL class and UNION concept is clear as 'mud'! Pat This forum looks better than any in US I've seen in a while. Couple of old ones but not getting updates.

I don't understand the reason for using a UNION query. Can someone help me on this one?:confused: Pat-City of Reno, NV