• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Help with converting table in MS ACCESS 2007 to an xml file

Hello,

When I try to convert my table into an xml file, (Right click table, export to xml) only 5 of the 8 columns appear in the xml file, how do I get all the columns to be included in the xml file?

Thanks,

Victor
0
vcharles
Asked:
vcharles
  • 3
  • 3
1 Solution
 
Carl TawnSystems and Integration DeveloperCommented:
What are the data types of your columns?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
As Carl Tawn suggests, some column types don't export, like Attachment and Multivalued Fields, OLE fields, hyperlinks, etc. I'm not sure about Memo, but it wouldn't surprise me if those did not export either.

When you do the export you have the Options button ... there's not much there, but you should review those to make sure the options are set correctly (they're very obvious, like Export Data, Export Schema, etc).
0
 
vcharlesAuthor Commented:
Hi,

All the columns are of type "Text".

Victor
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Compact the database before doing this.

Also, be sure your Office and Windows installs are up to date.

If you still have troubles, upload your database here so we can look into it. Be sure to remove or obfuscate any sensitive information first.
0
 
vcharlesAuthor Commented:
Hi,

What do you mean by compact the database?

Victor
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Compact is a maintenance process, and is a good thing to do on a regular basis.

In 2007, click the Office button (the big round button), then click Manage, then Compact.

Here's an MSFT article that gives you some background on what Compact does ...

http://support.microsoft.com/kb/288631
0
 
vcharlesAuthor Commented:
Thank You.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now