VBA Script to parse XML and create records in two tables

Finalizat Postat la acum 5 ani S-au achitat serviciile după ce au fost prestate
Finalizat S-au achitat serviciile după ce au fost prestate

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]

Visual Basic pentru aplicaţii

ID Proiect: #17754353

Detalii despre proiect

4 propuneri Proiect la distanță Activ acum 5 ani

Acordat lui:

abhinovpankaj

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 Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% USD în 2 zile
(23 Recenzii)
4.6

4 freelanceri plasează o ofertă medie de 28$ pentru proiect

vsprybhanu

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 Mai multe

$30 USD în 1 zi
(27 recenzii)
4.6
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. looking to hearing from you. Kind regards

$30 USD în 1 zi
(12 recenzii)
4.2
bijuenathu

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

$15 USD în 1 zi
(0 recenzii)
0.0