View Full Version : Access 2007: XML Error on exporting query?


The1nk
07-11-2008, 12:19 PM
Hello there! :p

I'm using Access 2007(no SQL server or anything funky, just Stand-Alone Access '07), and trying to export a query. The query is just two tables joined together with some criteria. There isn't anything too special about it. There is a memo field contained within this query. We export this using Excel 2000-2003 format (not '07s .XLSX format) because some of the office is still using '03. I also cannot "Preserve Formatting" on the export, because if I do it truncates my memo field down to 255 characters. And... Low and behold! I get an error! ^_^

"The specification XML failed to validate against the schema. Whitespace is not allowed here." or something like that. :confused:

Please help :confused:

Thanks.

WayneRyan
07-12-2008, 10:35 AM
The1nk,

Just a Google search ... might help:

http://blog.mpecsinc.ca/2007/12/office-2007-configxml-error-whitespace.html

Wayne

The1nk
07-14-2008, 05:53 AM
I had already stumbled acrossed that. I don't believe that pertains to my issue? It could in some abstract way, but I had no issue installing Office '07. This issue is when I am running a query. :(

Thank you for taking the time to reply :)