Link to home
Start Free TrialLog in
Avatar of Buck Beasom
Buck BeasomFlag for United States of America

asked on

What is the syntax for exporting an Access table to xml WITHOUT the Schema of Data information?

I need to export a single table to xml. I want to put the code behind a button.

Thanks.
Avatar of Rgonzo1971
Rgonzo1971

Hi,

pls try

Application.ExportXML ObjectType:=acExportTable, DataSource:="YourTable", DataTarget:="c:\yourTable.xml"

Regards
Avatar of Buck Beasom

ASKER

So no argument is required to keep it from including the schema in the xml? (It works, but I don't know enough about xml files to tell if the schema is in it.)

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Outstanding. Thanks!