?
Solved

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

Posted on 2014-02-28
7
Medium Priority
?
253 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 85
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 85
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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

649 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