Solved

problem creating XML file in Access 2013

Posted on 2014-11-27
4
134 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
  • 2
  • 2
4 Comments
 
LVL 62

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: 40469871
0
 

Author Comment

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

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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 …
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

759 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

20 Experts available now in Live!

Get 1:1 Help Now