Error in access paramater when exporting to xml

Lester Hitchcock 1 Reputation point
2021-09-20T15:56:52.517+00:00

I can export to any format but XML this database queries were created under access 2003 and worked fine to access 2010 but now that we have moved to access 2019 it gives an error when trying to export in xml and only xml.
see attached photo that should be start date not characters
133609-image.png

133656-access.jpg

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
844 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. C Data 6 Reputation points
    2021-09-21T01:45:40.617+00:00

    my experience with the oriental characters has always been due to a corrupted record in a table. the record can sometimes be found by sorting the table to have it appear at the top... the record must be deleted.

    why xml is unclear.

    look into the table(s) that are the source for the query... you also might experiment in writing the query records to a temp table and then attempt to export to xml from a temp table rather than from a query... just an experiment. maybe will point to a solution.