Web Development



access 2007 xml export from query with wildcards

By rshrake ·
I have a large Access 2007 database that has been segmented into sections by queries based on criteria in one field. To complete this segmentation, I needed to use wildcards to return all information. For example, data in the field might read, "B22" or "B22.1" but they must be associated, so I I used criteria "B22 or B22*"

The queries work fine and I have all of my data arranged properly. I'm now trying to export this data to xml, which is where I face the problem. Information from a query that uses a wildcard is not included in the xml output.

It seems that the xml export functionality is including that query information rather than just pulling the data from the datasheet.

Has anyone else run into this problem, and is there a reasonable fix?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums