Solved

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

Posted on 2014-02-28
7
248 Views
Last Modified: 2014-03-02
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
Comment
Question by:vcharles
[X]
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
  • 3
  • 3
7 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39894818
What are the data types of your columns?
0
 
LVL 84
ID: 39894876
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
 

Author Comment

by:vcharles
ID: 39894892
Hi,

All the columns are of type "Text".

Victor
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 84
ID: 39896965
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
 

Author Comment

by:vcharles
ID: 39897173
Hi,

What do you mean by compact the database?

Victor
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 39897267
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
 

Author Closing Comment

by:vcharles
ID: 39899579
Thank You.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

730 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