Or you write an intermediate system (such as a SSIS package) which translates their mess into something that's actually useable.