I can relate to that - we used to have two related systems which couldn't talk to each other. So the solution was to print out (landscape, tiny font) 1000's of lines from one system, then sit with a ruler and highlighter pen re-typing it into the other. Day in, day out.
A newer system which replaced some of the functionality and cost many millions of dollars will only export as .xls and only import from .csv (no API offered). Better than typing it in by hand, but it still pains me every day :-/
A newer system which replaced some of the functionality and cost many millions of dollars will only export as .xls and only import from .csv (no API offered). Better than typing it in by hand, but it still pains me every day :-/