Solved

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

Posted on 2014-02-28
7
245 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

920 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

12 Experts available now in Live!

Get 1:1 Help Now