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.
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.