VBA Script to parse XML and create records in two tables
$10-30 USD
Paid on delivery
The script in the attached [login to view URL] is used in Microsoft Access 365. It monitors the folder C:\123 for new files every 60 seconds. When a new file is created there it displays a message box.
I need code to that instead of displaying a message box will:
- Load XML from an xml file created in that folder (ignore if file is not .xml)
- Create a record in the table "ListOrdersResponse" with using the xml file name as ListOrdersResponseId and populate any of the other fields where the corresponding elements have attributes in that file.
- For each "AmazonOrderId" in the xml file, create a record in the table "Order" and populate any of the other fields where the corresponding elements have attributes in that file, again using the using the xml file name as ListOrdersResponseId
Note regarding naming in tables:
You can change these if you wish. Currently, fields are named the same as the corresponding elements. Where there are child nodes they are named ParentNode_ChildNode_ChildNode. The exceptions are the 2 "PaymentExecutionDetails" nodes due to length - these are shortened to PaymentED_PaymentExecutionDetailItem_Payment_CurrencyCode and PaymentED_PaymentExecutionDetailItem_Payment_Amount.
Please see attached files. [login to view URL] is a sample. [login to view URL] contains (edited) real information. Please note that they use the same element names, but they are in a different order, some are not included in each and example456 contains more than one order.
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
Project ID: #17754353
About the project
Awarded to:
Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More
4 freelancers are bidding on average $28 for this job
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop a macro to parse xml files and create tables I have done mostly Excel VBA Programming job. Plea More
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. looking to hearing from you. Kind regards
Hi, I have 20 years of experience in developing MA Access appliucation. I offer my expertise to parse xml data into MS Access table as per your requirement. Thanks, Biju