Exporting query to XML with VBA and missing a record

J

Jeff

Hi

I'm writting an application that exports the results of a query to an XML
file. The query returns 231 record but when I look at the xml file in excel
there are only 230 rows. What wrong?
Here is the VBA

nameFile = "Production" + CStr(Format(Now(), "_yyyymmdd")) + ".xml"
Application.ExportXML ObjectType:=acExportQuery,
DataSource:="qryProduction", _
DataTarget:=nameFile

Anybody got any suggestion why the last row is not being exported?

Thanks
Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export query to XML file 4
export xml - slow Access 2007 5
Exporting data to xml file 3
exporting an access query to XML using an external stylesheet or ( 0
Exporting linked tables to XML 0
Transforming XML to HTM with VBA 0
Exporting a Query to an XML File 4
Automatically export a query to XML with Access 2003 1

Top