Solved

problem creating XML file in Access 2013

Posted on 2014-11-27
4
141 Views
Last Modified: 2014-12-01
this is what I get<infoTable xmlns="">
The requirement is that there be no name space tags on any elements.
code.txt
test2.inftab.xml
0
Comment
Question by:durick
[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
  • 2
  • 2
4 Comments
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 40469293
Hi durick;

If you do not want any namespace in the document then try removing these lines from your code.

'eleInformationTable.setAttribute "xsi:schemaLocation", "http://www.sec.gov/edgar/document/thirteenf/informationtable eis_13FDocument.xsd"
eleInformationTable.setAttribute "xmlns", "http://www.sec.gov/edgar/document/thirteenf/informationtable"
'eleInformationTable.setAttribute "xmlns:n1", "http://www.sec.gov/edgar/document/thirteenf/informationtable"
eleInformationTable.setAttribute "xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance"

Open in new window

0
 

Author Comment

by:durick
ID: 40469872
does not explain the - <infoTable xmlns=""> entries
0
 
LVL 63

Accepted Solution

by:
Fernando Soto earned 500 total points
ID: 40471592
The question states, "The requirement is that there be no name space tags on any elements.", but yet the root node does have a namespace associated with it.

From your last post, "does not explain the - <infoTable xmlns=""> entries", this statement from your code,

eleInfoTable = docDocument.CreateElement("infoTable")

which uses a single string as a parameter does not insert a namespace into the node. I would look at your code again and make sure you are not using the one with two string parameters of which the second one would be the namespace.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

724 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