I will mark this as resolved for now. I have come up with a solution for now.

Just added a query into my automation macro, that links primary keys from the original table and then the return table, and i just overwrite the dates in the return table with those from the original.

Works fine for what i need it to do. I am still interested in how to deal with local region settings that excel/access both format to. Not sure how you deal with that while in Date format, other than changing the data type to string so that it doesnt get changed.