Save XML as an ADO recordset

[admin]

Hi -I am working with an XML feed from a Seibel system. The object of thisexercise is to move that data to another SQL Server based system.Now, I was told that it is possible to save an XML file as an ADODBrecordset. I have been looking through the different help files and haven'tfound any references to this particular capability. I am familiar with thestandard methods of persistence but, when I apply them to this situationthey don't work. A fragement of the XML file is below.<Account><Id>1-6</Id><Created>03/26/1996 12:21:00</Created><Updated>03/27/2000 18:52:15</Updated><ConflictId>0</ConflictId><AccountCompetitors>Typical competitors for this account include several ofthe freight consolidators, as well as the major transportation companies inrail and shipping.</AccountCompetitors><AccountCondition>High growth account with consistently profitableoperations and impressive growth trends. Look for high potential over thenext few years.</AccountCondition><AccountMarkets>A.K. Parker operates primarily in the automotive industry,where on time delivery of parts is critical. The company offers manyspecialized services in this vertical, as well as in several other areas ofmanufacturing.</AccountMarkets><AccountProducts>A.K. Parker offers an entire line of distribution services,from scheduled services to special services to overnight fulfillment ondemand. They are consistent innovators in their field, delivering newofferings to their customers on a quarterly or monthly basis in somecases.</AccountProducts><AccountRole></AccountRole><AccountStatus>Gold</AccountStatus><AccountTrend>2-Growth</AccountTrend><Alias></Alias><AnnualRevenue>500000000</AnnualRevenue><AssignmentAreaCode></AssignmentAreaCode><AssignmentCountryCode></AssignmentCountryCode><AssignmentExcluded>N</AssignmentExcluded><BackOfficeDistributionChannel></BackOfficeDistributionChannel><BackOfficeSalesArea></BackOfficeSalesArea><BackOfficeSalesAreaDivisionCode></BackOfficeSalesAreaDivisionCode><BackOfficeSalesOrganization></BackOfficeSalesOrganization><BusinessProfile>A.K. Parker is a high tech distribution company with veryhigh growth rates and considerable levels of competition. Our products willprovide A.K. Parker with exactly the kind of edge they need in servicingtheir customers and selling to their prospects.</BusinessProfile><CSN>10-101</CSN><Competitor>N</Competitor><CurrencyCode>USD</CurrencyCode><CurrentVolume>350000</CurrentVolume><CurrentVolumeCurrencyCode></CurrentVolumeCurrencyCode><CurrentVolumeExchangeDate></CurrentVolumeExchangeDate><DUNSIntcode>1</DUNSIntcode><DUNSNumber></DUNSNumber><DateFormed>03/01/1954 00:00:00</DateFormed><DeDupToken>94025AI</DeDupToken><DeduplicationMatchScore></DeduplicationMatchScore><DeduplicationObjectId></DeduplicationObjectId><Description>This is the key account in the AK Parker Family</Description><DisableDataCleansing>N</DisableDataCleansing><DisableMailings>N</DisableMailings><Division></Division><DomesticUltimateDUNS></DomesticUltimateDUNS><Dummy></Dummy><EmployeeHere>200</EmployeeHere><Employees>1500</Employees><Expertise></Expertise><ExplorerLabel>10-101 - A. K. Parker Distribution,HQ-Distribution</ExplorerLabel><FiscalYearEnd>12/31/1998 00:00:00</FiscalYearEnd><FreightTerms></FreightTerms><FreightTermsInfo></FreightTermsInfo><GlobalUltimateDUNS></GlobalUltimateDUNS><Goals>1. $150mm in revenues within a year.2. An increase of 4% in market share.</Goals><HomePage>www.parker.com</HomePage><IndustryCondition>Somewhat mature, with small increases in demand on anannual basis. The larger players are consolidating their hold over marketshare, while a few upstarts manage to grow fairly well.</IndustryCondition><IndustryTrend>3-Stable</IndustryTrend><IntegrationId></IntegrationId><JoinedSynonym>Parker Dist - HQ</JoinedSynonym><KeyCompetitors></KeyCompetitors><LanguageCode></LanguageCode><LineofBusiness>Manufacturing</LineofBusiness><Location>HQ-Distribution</Location><LocationLevel></LocationLevel><MainFaxNumber>4153296511</MainFaxNumber><MainPhoneNumber>4153296500</MainPhoneNumber><Mission>A.K. Parker&apos;s mission is to provide its customers with thehighest quality products available on the marketplace, quickly.</Mission><Name>A. K. Parker Distribution</Name><NameandLocation>A. K. Parker Distribution:HQ-Distribution</NameandLocation><Objectives>1. Ongoing orders from existing customers.2. Growing customer base through high quality reputation.</Objectives><Organization>North American Organization</Organization><OrganizationId>1-24E1</OrganizationId><OurPosition></OurPosition><ParentAccountDivision></ParentAccountDivision><ParentAccountId>1-1</ParentAccountId><ParentAccountIntegrationId></ParentAccountIntegrationId><ParentAccountLocation>HQ-Corporate</ParentAccountLocation><ParentAccountLocationLevel></ParentAccountLocationLevel><ParentAccountName>A. K. Parker Inc.</ParentAccountName><ParentAccountRegion></ParentAccountRegion><ParentHQDUNS></ParentHQDUNS><PartnerFlag>N</PartnerFlag><Partners></Partners><Philosophy>Somewhat of a rebel in their field, changing the models used forthe last five to ten years. Success through pushing the traditionalboundaries of product offering.</Philosophy><PriceList>North American Price List</PriceList><PriceListEndDate>12/01/2003 00:00:00</PriceListEndDate><PriceListId>1-2GOY</PriceListId><PriceListStartDate>01/01/2000 00:00:00</PriceListStartDate><PrimaryAccountCity>Menlo Park</PrimaryAccountCity><PrimaryAccountCountry>USA</PrimaryAccountCountry><PrimaryAccountPostalCode>94025</PrimaryAccountPostalCode><PrimaryAccountState>CA</PrimaryAccountState><PrimaryAccountStreetAddress>1000 IndustrialWay</PrimaryAccountStreetAddress><PrimaryAddressId>1-7</PrimaryAddressId><PrimaryAssignmentDenormFlag>N</PrimaryAssignmentDenormFlag><PrimaryAssignmentManualFlag>N</PrimaryAssignmentManualFlag><PrimaryAssignmentSystemFlag>N</PrimaryAssignmentSystemFlag><PrimaryAssignmentType>MANUAL</PrimaryAssignmentType><PrimaryBillToAddressId>1-7</PrimaryBillToAddressId><PrimaryBillToCity>Menlo Park</PrimaryBillToCity><PrimaryBillToCountry>USA</PrimaryBillToCountry><PrimaryBillToFirstName>Stan</PrimaryBillToFirstName><PrimaryBillToJobTitle>Senior Mgr of MIS</PrimaryBillToJobTitle><PrimaryBillToLastName>Graner</PrimaryBillToLastName><PrimaryBillToPersonId>1-161</PrimaryBillToPersonId><PrimaryBillToPostalCode>94025</PrimaryBillToPostalCode><PrimaryBillToState>CA</PrimaryBillToState><PrimaryBillToStreetAddress>1000 Industrial Way</PrimaryBillToStreetAddress><PrimaryCategoryId></PrimaryCategoryId><PrimaryFulfillmentInvLocID>1-2U0B</PrimaryFulfillmentInvLocID><PrimaryFulfillmentInventoryLocation>San FranciscoWarehouse</PrimaryFulfillmentInventoryLocation><PrimaryIndustryId>574</PrimaryIndustryId><PrimaryPayerAccount></PrimaryPayerAccount><PrimaryPayerAccountId></PrimaryPayerAccountId><PrimaryPositionId>1=53D</PrimaryPositionId><PrimaryServiceAgreementId>24-25NG</PrimaryServiceAgreementId><PrimaryShipToAddressId>1-7</PrimaryShipToAddressId><PrimaryShipToCity>Menlo Park</PrimaryShipToCity><PrimaryShipToCountry>USA</PrimaryShipToCountry><PrimaryShipToFirstName>Stan</PrimaryShipToFirstName><PrimaryShipToJobTitle>Senior Mgr of MIS</PrimaryShipToJobTitle><PrimaryShipToLastName>Graner</PrimaryShipToLastName><PrimaryShipToPersonId>1-161</PrimaryShipToPersonId><PrimaryShipToPostalCode>94025</PrimaryShipToPostalCode><PrimaryShipToState>CA</PrimaryShipToState><PrimaryShipToStreetAddress>1000 Industrial Way</PrimaryShipToStreetAddress><PrimarySynonymId>1-B3V</PrimarySynonymId><PrimaryTerritoryId>No Match Row Id</PrimaryTerritoryId><PrimaryTypeId>1-2YH</PrimaryTypeId><Profit>22000000</Profit><ProjectBillType></ProjectBillType><ProjectComments></ProjectComments><ProjectFixFee></ProjectFixFee><ProjectHourLimit></ProjectHourLimit><ProjectId></ProjectId><ProjectName></ProjectName><ProjectPercentageofFee></ProjectPercentageofFee><ProjectPurchaseOrder></ProjectPurchaseOrder><ProjectRelationshipType></ProjectRelationshipType><ProjectRole></ProjectRole><ProspectFlag>N</ProspectFlag><Public>Y</Public><Region></Region><Revenue>120000000</Revenue><RevenueGrowth>22</RevenueGrowth><RowStatusAsterisk> </RowStatusAsterisk><Strategies>Positioning as a responsive supplier with all the right ties andplenty of personal attention.</Strategies><SuccessFactors>1. Attention to their existing customer base and to theirongoing customer sat.2. Brand marketing in their major markets and verticals.3. High quality and high level, executive ties.</SuccessFactors><TerritoryItemType></TerritoryItemType><Timestamp>03/17/2001 20:02:47</Timestamp><Today>03/17/2001 00:00:00</Today><TotalPotentialVolume>1500000</TotalPotentialVolume><TotalPotentialVolumeCurrencyCode></TotalPotentialVolumeCurrencyCode><TotalPotentialVolumeExchangeDate></TotalPotentialVolumeExchangeDate><Type>Commercial</Type><WebphoneName>-A. K. Parker Distribution-</WebphoneName><ListOfAccount_BusinessAddress><Account_BusinessAddress><AddressId>1-7</AddressId><City>Menlo Park</City><Country>USA</Country><FaxNumber></FaxNumber><PhoneNumber></PhoneNumber><PostalCode>94025</PostalCode><Province></Province><State>CA</State><StreetAddress>1000 Industrial Way</StreetAddress><IntegrationId></IntegrationId></Account_BusinessAddress><Account_BusinessAddress><AddressId>24-23CX</AddressId><City>San Francisco</City><Country>USA</Country><FaxNumber></FaxNumber><PhoneNumber></PhoneNumber><PostalCode>94408</PostalCode><Province></Province><State>CA</State><StreetAddress>322 Arkansas Street</StreetAddress><IntegrationId></IntegrationId></Account_BusinessAddress></ListOfAccount_BusinessAddress><ListOfAccount_Industry><Account_Industry><Industry>manufacturing industries</Industry><SICCode>3999</SICCode></Account_Industry></ListOfAccount_Industry></Account>