Export to XML

[Pauldohert]

I am using file/export and choosing XML but it won't work just get the error "can't export the data"

Can export to csv, xls etc

what do I need to do to export to XML?

I'm using access XP.


Thanks

 

[reclusivemonkey]

Paul,

Can you give a brief snippet of what you are trying to export in a text file? As far as I am aware, you don't need anything installed to export to XML. I certainly didn't have to do anything special to get XML working.

 

[Pauldohert]

I'm in the database window and choose one of my tables and then file/export etc - but the error above?

Have tried on another PC using access 2003 and it works ok?

Thanks

 

[reclusivemonkey]

Paul,

Are you exporting a schema as well? I'm on XP as well, with Access 2002. XML is a non-proprietry format, so you don't need anything special. Have you tried exporting via VBA see if you get any joy that way? I use this function (error trapping is for wimps ;-)

Public Function ExportXML(ByVal TableName As String, ByVal FileName As String)
' Function to export a table as XML
' Tell the user which table we are exporting, and give them a chance to cancel
If MsgBox("Exporting table " & TableName, vbOKCancel) <> vbOK Then
        End
    Else
        Application.ExportXML acExportTable, TableName, "P:\Finance\intranet\" & FileName ' Export the table
        MsgBox "" & TableName & " exported to P:\Finance\intranet\" & FileName ' Let the user know we are done
End If
End Function

 

[Pauldohert]

Thanks, tried that - get error

2950 reserved error

 

[reclusivemonkey]

I have no idea why it isn't working. I have just gone into my DB, and trying to export any old query to XML gives the same error, however, with most of the simple tables and queries I use, I have no problems, and these are exports which are carried out daily.

Again, if you can, showing an example of that data you are trying to export might help.

 

[Pauldohert]

The data is just rubbish to test this with - fields AAAA and BBBB and one record - the fields are text - and thats it.

AAAA BBBB
dddd dddd

 

[reclusivemonkey]

According to google;

If the path you specify isn'ta valid path, VBA will return error 2950

 

[Pauldohert]

Have rechecked that and its a valid path

 

[reclusivemonkey]

No idea.

Try this;

I made a simple DB with a table with the names of the days of the week. I can right click and export to XML on my machine. See if this works. If not I suspect its something on your machine. The DLL responsible for XML is MSXML.DLL so its possible that has become corrupt.

 

[Pauldohert]

Thanks tried your db - still the same.

Hmm - I'm stuck.

 

[reclusivemonkey]

Hmm - me too!

Have you checked for MSXML.DLL? I've not found anything on google really. Are you using Access 2002? You could try asking on one of the microsoft.public.access newsgroups.

Do you want to post your DB see if I can get it to export this end?

 

[Pauldohert]

Have tried it on the Access 2003 pc and also an Access XP machine and its fine - I assume it would work on yours - have tried differant db and differant objects to export all with no success.

What should I be checking for MSXML.DLL ?

 

[reclusivemonkey]

Search for it in XP and post a screenshot of the properties. Its the XML parser, which I believe is responsible for creating the XML. AFAIK, you need that and MDAC working to get XML export. If you have it working on two other machines, one of the XP, I just *has* to be a corrupt file or something on that particular machine. Is this a work machine? Does it have all the service pack files installed? I'm at home now, but I remember when I looked for MSXML today there was one in the service pack folder. You can get the latest MSXML from Microsoft (it may need admin rights).