error “2302 Can’t save output data to the file you selected.” Save as XML file (1 Viewer)

[Roy]

I am using Microsoft Access 2010 to write VBA code to save an Access table as an XML file. I have tried running on computers with Windows 10 and Windows 8.1 In both cases I get the error “2302 Can’t save output data to the file you selected.” Here is the code I’m using

Sub cmdxml_Click()
Dim objOtherTbls As AdditionalData
On Error GoTo ErrHandler
Set objOtherTbls = Application.CreateAdditionalData
' table to export
objOtherTbls.Add "tblAssociates"
'export here
Application.ExportXML ObjectType:=acExportTable, DataSource:="tblAssociates", _
DataTarget:=" C: \Documents\rayBuild\EmployeeData.xml", _
AdditionalData:=objOtherTbls
MsgBox "Export operation completed successfully."
Exit Sub
ErrHandler:
MsgBox Err.Number & " " & Err.Description
End Sub

I have used the ribbon External Data, Export, XML Data and successfully save an XML and SD files.
Any help getting the VBA code to work is appreciated

Thanks

 

[jdraw]

I have not used this M$oft MSAccess info on Exporting to XML but did find it via Google

 

[Orthodox Dave]

There's also this link, which looks simpler:
https://msdn.microsoft.com/en-us/vba/access-vba/articles/additionaldata-object-access

But before that, did you copy the code direct from your sub? In which case:

DataTarget:=" C: \Documents\rayBuild\EmployeeData.xml"

contains a space after C: