This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Help!!! Using the Import Text Wizard I am attempting to import text files into a table in Access 2007 (The database was developed in Access 2000 and later converted to 2003 - all macros and visual basic coding worked well) First I got the Utility.mda message and unchecked that now I am getting a message "The specification XML Failed to validate against schema. There is an error in the following line of the XML document:1."
Note that the document is a text file even though the error message refers to an XML document.
Can someone help me pls - much appreciated.
My operating system is Window 7
Methals
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Thank you Gina - I recreated the Specs in the import (long task) and renamed it - that worked. Greaat way to end a Friday - Thanks again.
Answer accepted by question author
What you would do is got to File - Import and run thru the import manually, clicking Advanced towards the end and then save the import giving it the same name as your previous import. If that doesn't work, give it a new name and see if that works.
And yes, this has been an ongoing issue...
--
Gina Whipp
2010 Microsoft MVP (Access)
Please post all replies to the forum where everyone can benefit.
Answer accepted by question author
I do have Access SP2 installed. I have been reading the Blogs and it seems that this has been a problem since 2007 - I have reinstalled 2003 and my Import works as it should. However I just upgraded to 2007 so I would naturally like to work in that.
I have several Date fields in my import and this according to some folks is the problem. I am importing the Dates into text fields, the dowload is in CToss which I later run a module to change to DOS. I looked at the Import Specifications. When you suggest recreating the Import Specifications - What do I have to change to make it work??
Answer accepted by question author
A couple of tings... make sure you have SP2 for Access 2007 installed and since you are not importing a XM file you could try recreating the Import Specification.
--
Gina Whipp
2010 Microsoft MVP (Access)
Please post all replies to the forum where everyone can benefit.
You're welcome!
--
Gina Whipp
2010 Microsoft MVP (Access)
Please post all replies to the forum where everyone can benefit.