I was about to post something about "let's not be elitist, everyone has to start learning somewhere" and then I read the chain. Even before I got to the "bad data" part of the talk, I knew that was the issue.
The industry may have standards, but standards aren't automatic. They have to be properly implemented for them to work. At a guess, the Access tables used quotes for some of the values instead of straight alpha-numeric values and that caused the files to export all wrong when they chose to use quotes to indicate the strings.
I don't understand people who think standards should be bulletproof. Heaven knows I've screwed up a few industry standards myself over the years. If I can do it, everyone can do it. @=)
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.