I'm trying to convert an XML file into an Excel database using a macro
but don't know where to even start (a newbie if you will).
The XML file format appears as listed below.
What I'd like to get the macro to do is take the headers (ie.
<REPORT_DATE, <DOMAIN_RECORD, <ADDRESS, etc) into proper records &
fields as: Rep_Date, Dom_Rec, Web_Addr,IP_Addr, Owner, Street,
City/State, Country, Phone, Fax, Email, etc
In the case where no info is available, that field would be left
blank.
Any help would be greatly appreciated as I've been trying to find
software to do this but have been unsuccesssful. It appears that a
macro would do the trick.
John
XML File Format:
<?xml version="1.0" encoding="utf-8" ?
<DATA
<REPORT_DATE3-Sep-2003</REPORT_DATE
<DOMAIN_RECORD
<ADDRESShollisterinc.com</ADDRESS
<IP_ADDRESS207.190.246.17</IP_ADDRESS
<OWNERHollister Associates, Inc.
24 School Street
Boston, MA 02108
US</OWNER
<ADMINISTRATIVE_CONTACTKip Hollister -
Hollister Associates, Inc.
24 School Street
Boston, MA 02108
US
Phone - 617-742-3020
Fax - 617-742-3357</ADMINISTRATIVE_CONTACT
<TECHNICAL_CONTACTDNS Admin -
CTC Communications
360 Second Avenue
Waltham, MA 02154
US
Phone - 800-883-6900
Fax -</TECHNICAL_CONTACT
<NAME_SERVERSNS3.CTCCOM.NET 64.69.100.67
NS4.CTCCOM.NET 64.69.100.35</NAME_SERVERS
<ADDITIONAL_DATA<CREATED2001-01-19</CREATED
<UPDATED2001-05-21 16:14:42</UPDATED
<EXPIRES2011-01-19</EXPIRES
<DATASOURCEwhois.bulkregister.com</DATASOURCE</ADDITIONAL_DATA
</DOMAIN_RECORD
<DOMAIN_RECORD
<ADDRESShowtoconquertheworld.com</ADDRESS
<OWNERWASNY, GARRETT
WASNY,GARRETT
SUITE 303-1132
VANCOUVER, BC V6E 1CP
CAN</OWNER
<ADMINISTRATIVE_CONTACTWASNY, GARRETT
WASNY,GARRETT
SUITE 303-1132
VANCOUVER, BC V6E 1CP
CA
604-878-4555</ADMINISTRATIVE_CONTACT
<TECHNICAL_CONTACTSupport, Tech
101 Marietta Street
Atlanta, GA 30303
US</TECHNICAL_CONTACT
<NAME_SERVERSA.NS.INTERLAND.NET 64.226.28.33
B.NS.INTERLAND.NET 69.0.145.33
C.NS.INTERLAND.NET 64.77.127.42</NAME_SERVERS
<ADDITIONAL_DATA<NETNAMEHOWTOCONQUERTHEWORLD-DOM</NETNAME
<CREATED13-Oct-2002</CREATED
<UPDATED2-Sep-2003 17:09:20 EDT</UPDATED
<EXPIRES18-Feb-2008</EXPIRES
<DATASOURCEwhois.networksolutions.com</DATASOURCE</ADDITIONAL_DATA
</DOMAIN_RECORD
</DATA