Thanks Joe for your request for further information.

Where I’m struggling is with taking an external file on my local machine 
(say a PDF format file) and converting this to a Base64 string for including 
in XML.  I can save the resultant XML as a file and convert a text string to 
Base64 it’s just accessing this external file and converting it which is 
challenging.

I note a solution that uses OLE objects but wanted to do this without this 
if possible.  (see 
http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/72575a42-3cb9-4637-9ce5-43b78076cf7a).

Thanks again for your help.

Mark
"Joe Fawcett" wrote:

> 
> "MarkTheAccountant" <MarkTheAccountant@d...> wrote in 
> message news:AC2C672B-022C-4D55-9361-CABAA4B5319A@m......
> > Hello
> >
> > I'm trying use XML and need to include an external file as a Base64 
> > encoded
> > string within an XML node.  I have seen examples converting a string to
> > Base64 and OLE Objects to Base64 encoded strings but I want to keep the 
> > file
> > external to the database.
> >
> > What would you suggest?  Should I consider using XMLWriter or
> > FileSystemObject?
> >
> > Thanks in advance.
> >
> > Regards
> >
> >
> > Mark
> 
> I don't really follow, are you having trouble adding the Base64 text to an 
> XML file or trouble creating the XML file to begin within? Can you clarify?
> Regards
> 
> -- 
> 
> Joe Fawcett (MVP - XML)
> http://joe.fawcett.name 
> 
>