Solved

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

Posted on 2014-09-11
4
122 Views
Last Modified: 2014-09-26
I need to export a single table to xml. I want to put the code behind a button.

Thanks.
0
Comment
Question by:Buck_Beasom
  • 2
  • 2
4 Comments
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 40318985
Hi,

pls try

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

Regards
0
 

Author Comment

by:Buck_Beasom
ID: 40319336
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.
0
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40319782
Hi
If I wanted to export the schema (another file it would be

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

Reference
http://msdn.microsoft.com/en-us/library/office/ff193212(v=office.15).aspx
0
 

Author Closing Comment

by:Buck_Beasom
ID: 40345949
Outstanding. Thanks!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now