By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Access 2013 export to xml

P: 9
I am expected to produce an xml as per the sample EDI claim xml that I have attached. I only managed to achieve it by using several queries as per the database that I am attaching.

When I export the date comes with time, I used the format date in the query to change it to date only, but when I put it in the other queries it refuse to export. I don't want the time there.

Another thing is I read another thread of someone who was able to edit the dataroot line, I would like to change mine to ClaimRequest, I tried his code but its refusing to work on access 2013. I will attach his database its called xml, mine is called sampledatabase

I will appreciate any assistance
Attached Files
File Type: zip SampleDatabase.zip (261.3 KB, 4 views)
File Type: zip xml.zip (67.2 KB, 4 views)
2 Weeks Ago #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,054
Please do not post a databsae unless we ask you to post the database. Please post any code and sample data in the thread itself. Many of us are not able to download such files at work.
2 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.