Question:
I know there are lot of threads, questions, and angst out there about maintaining formatting during Access/Excel importing and exporting operations.
Generally there isn't anyway to maintain formatting during these processes, but I have observed the following:
When I use VBA DAO...