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

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

Question by:Buck_Beasom
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 50

Expert Comment

ID: 40318985

pls try

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


Author Comment

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.)

LVL 50

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 40319782
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"


Author Closing Comment

ID: 40345949
Outstanding. Thanks!

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
outlook 2010 on exchange 2010 disconnect message 11 39
How to use a BLANK in a complex formula 3 26
Contact management 16 266
SQL server client app 3 32
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site ( in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

733 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