Bulk insert into xml file

[londontown1]

I have a xls file and a txt(xml) file.
I need to import the data from the xls file to the txt (xml) file
The xls file has 500 rows of data

But the xml file must have a set format with some static data:

<FeedMsg>
<CoreItemsMkt xmlns="

http://www.hi.co.uk/XMLSchema/Feed-v1-1">

<FirmFSARef>
172330
</FirmFSARef>
<TransRef>
4649606
</TransRef>
<Cancellation>
false
</Cancellation>
<Status>
N
</Status>
</CoreItemsMkt>
<Transaction>
<ReportingFirmId>
<ReportingFirmCode type="R">
172330
</ReportingFirmCode>
</ReportingFirmId>
<TradingDate>
COLUMN 1
</TradingDate>
<TradingTime>
COLUMN 2
</TradingTime>
<BuySell>
COLUMN 3
</BuySell>
<TradingCapacity>
P
</TradingCapacity>
<InstrumentIdentification>
<InstrumentIdentificationCode type="I">
COLUMN 4
</InstrumentIdentificationCode>
</InstrumentIdentification>
<TypeOfInstrument>
A
</TypeOfInstrument>
<UnitPrice>
COLUMN 5
</UnitPrice>
<PriceNotation>
COLUMN 5
</PriceNotation>
<Quantity>
COLUMN 6
</Quantity>
<CounterpartyOne>
<CounterpartyCode type=" COLUMN 7">
COLUMN 8
</CounterpartyCode>
</CounterpartyOne>
<VenueIdentification>
XLON
</VenueIdentification>
</Transaction>
</MarketsFeedMsg>
</MarketsFeed>


Only the bit which read COLUMN# are the sections coming from the xls file.

 

[tsuji]

The question should be first posted to office forum:

http://tek-tips.com/threadminder.cfm?pid=68

and listen to their advice on re-direction.