troubleshooting Question

MS Access How To Change a XML File Element Value With a Value In a Field From a Table

Avatar of Dustin Stanley
Dustin Stanley asked on
XMLMicrosoft AccessVBA
14 Comments1 Solution565 ViewsLast Modified:
I have a XML file and in that XML file is an element called <SessionID> For the value of SessionID I need to insert whatever value I have currently in the Field "SessionID" in the table called "GetSessionIDResponse".

The XML file is on my PC in a folder.

Here is the XML example:
<?xml version="1.0" encoding="utf-8"?>
<FetchTokenRequest xmlns="urn:ebay:apis:eBLBaseComponents">
  <!-- Call-specific Input Fields -->
  <SecretID> string </SecretID>
  <SessionID> string </SessionID>
  <!-- Standard Input Fields -->
  <ErrorLanguage> string </ErrorLanguage>
  <MessageID> string </MessageID>
  <Version> string </Version>
  <WarningLevel> WarningLevelCodeType </WarningLevel>
</FetchTokenRequest>

How can I make this happen? Thanks!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros