Export XML file from Access....

[Udeshi]

i have an access table with few blank cells inside.
when i export xml file, those blank cells are not showing in the xml file.



eg: <work_note_table>
<WIKey>xxxxx</WIKey>
<WIName>xxxxx</WIName>
<WSKey>xxxxx</WSKey>

but there is another data cell for this row (WIType) and is blank.
i want to show that entry also as empty.
How can i export the file showing that entry too?

[ItsMe]

Sounds like you have a text field with a null value. If this is the case you could build an Access query dedicated for your export. In the query you could add a field that would return the phrase "NoData" where a null value exists.

Assuming you have a Table named tblData and a Field called txtTextWithNullValues you could insert the following into the field properties of a new query.

NewField: IIf([tblData].[txtTextWithNullValues] Is Null,"NoData",[tblData].[txtTextWithNullValues])

You can do the same for number values that are returning Null or run an update query to fix your original table and insert zeros.

hope this helps......