Thanks Zack. I have to go through access to obtain the data off our server (TN). There is probably a way to do that via VBA, but that is WAY over my head

I tried your code, and at first it didn't work (deleted the rows but didn't copy). Then I noticed your copy sequence was from Ws1 to Ws1. I changed Ws1 to Ws2 and it worked great.

Thanks for your time