Solved

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

Posted on 2014-02-28
7
244 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
  • 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

758 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

18 Experts available now in Live!

Get 1:1 Help Now