I've tried the following from what i read and turned it into an XML, I believe anyway but could be totally wrong - still though even though i've turned it into an XML still no closer to inserting it into a table.

DECLARE @t TABLE

(

XMLData VARCHAR(8000)

)

INSERT INTO @t(XMLData)

VALUES

(

'<?xml version="1.0" encoding="UTF-16"?>

<!DOCTYPE Announcement SYSTEM "CapReport.dtd" >

<Announcement>

<Template>Capital Report System</Template>

<Headline>

<SubmittedWrt>Test</SubmittedWrt>

<Announcement_Title>CapitalReport</Announcement_Title>

<BroadcastDate>24-Oct-2012</BroadcastDate>

<BroadcastTime>10:02:54</BroadcastTime>

</Headline>

<Full_News>

<Code>AAA</Code>

<Ref_No>00001</Ref_No>

<AnnouncedBy>ABC123</AnnouncedBy>

<SG_ComRegNo>001</SG_ComRegNo>

<SubmittedFor>ABC123</SubmittedFor>

<SubmittedWrt>ABC123</SubmittedWrt>

<AnnouncerName>TestAnnouncement</AnnouncerName>

<Designation>TestAnnouncement</Designation>

<BroadcastDate>24-Oct-2012</BroadcastDate>

<BroadcastTime>10:02:54</BroadcastTime>

<PriceSensitivity>No</PriceSensitivity>

<ContactNo>TestAnnouncement</ContactNo>

<SubmissionDate>24/10/2012</SubmissionDate>

<SubmissionTime>10:02:29 AM</SubmissionTime>

<Announcement_Details>

<ChangeInCapital>Rights</ChangeInCapital>

<Capital_AnncTitle>TestAnnouncement</Capital_AnncTitle>

<ShareHolderApp>No</ShareHolderApp>

<TextAns_Description>TestAnnouncement</TextAns_Description>

<Attachment>TestAnnouncement123.pdf</Attachment>

</Announcement_Details>

</Full_News>

</Announcement>'

)

DECLARE @xVar XML

SET @xVar = (SELECT * FROM @t FOR XML AUTO,TYPE)

SELECT @xVar