Question: 5. Jing is also tracking prospective clients for Hexagon Engineering. She has two XML files containing 13/13 prospect data, and asks you to import them.

5. Jing is also tracking prospective clients for
5. Jing is also tracking prospective clients for Hexagon Engineering. She has two XML files containing 13/13 prospect data, and asks you to import them. Go to the Prospects worksheet. Open the XML Source pane and add the XML schema Support EX19_10a_Prospects.xso to the workbook. Import an XML map into a workbook. 6. Map the XML elements as shown in Table 1. 13/13 Map XML elements to a workbook. 7. Import the two XML files as follows: 0/13 a. Set the XML map properties to validate imported and exported data against the schema and append new data to existing XML tables. ( Hint: Use the XML Map Properties option available on the table's shortcut menu.) b. Import the XML data from the file Support_EX19_10a_Prospects.xml into the worksheet at cell Al. c. Import the XML data from the file Support_EX19_10a_Prospects2.xml into the worksheet at cell A6. d. Close the XML Source pane. X Import data from an XML map into a workbook. In the Prospects worksheet, the range Al:D5 should contain data from the XML file Support_EX19_10a_Prospects.xml. X Import data from an XML map into a workbook. In the Prospects worksheet, the range A6:08 should contain data from the XML file Support EX19_10a_Prospects2.xml

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!