VPN will do what you are needing, whether it's practical or not you need to decide.
How important is the data? If it's extremely confidential, don't do VPN.
How important is up time? A frame relay connection would tend to be more reliable than a VPN connection.
How large are the files and what speed DSL will you be using?
Do you currently have static IPs from both ISP's? If not, you will.
Do you run specialty programs written exclusively for your company? If so you will need to contact them to see if they know of any issues. A VPN is not an always on connection, per se. If you let it run idle it will close itself off so to speak until you initiate traffic on it again. Some programs will see this as a lost connection. In my case it was a terminal emulation program for a Credit Union. The fix was simple, I just had to use keep-alives.
Anyway, in a nutshell, a VPN is transparent to the end user. When set up, they won't know if a mapped drive is on a server in the next room or the next continent (unless of course you're on a slow connection.)
Good luck.