Access 2007 Bug
Access 2007 breaks previous text import specs if you deal with dates (at least of format yyyymmdd) in the text file.
The specs imported these fields properly in Access 2003. In 2007, you get an error
"The specification XML failed to validate against the schema. There is an error in the following line of the XML document: ."Those specs that have no date fields seem to import without problems.
I posted a question about this on the Microsoft newsgroups, which should be the right place to post. No answers.
Then I moved on to the Joel on Software forums, where I often have better luck. Albert D. Kallal, MVP for Access, was able to reproduce the issue and filed a bug report.
My guess is that this is not very high priority for a bug fix, since I don't see anyone else complaining about it on any forums. Is it really that unusual to import text files? I would have thought thousands of people would be affected by this...