troubleshooting Question

best method for creating xml file using msaccess

Avatar of tazpaj
tazpajFlag for United States of America asked on
Microsoft Access
10 Comments1 Solution317 ViewsLast Modified:
I will preface this with prior to this week I had zero experience with XML.

I have been tasked with creating an XML file from data that I would typically pull via MSAccess or Crystal Reports. I have played with creating queries this week and linking them via relationships, but am struggling on determining if this is the best method to create these files as it seems to get me close but not close enough and I'm not sure how to alter the output automatically and the data is too big to update manually. I'm wondering if writing a module would be easier in the long run but was wondering if anyone had a simple outline of code that would get me started as I'm very overwhelmed at the moment.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
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 10 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