PDA

Click to See Complete Forum and Search --> : XML from MDB

AWhiteC
03-10-2003, 04:56 AM
What's the easiest way to convert an MDB file (Access database) to an XML file? (Oh, and what's the cheapest way??)
khalidali63
03-10-2003, 08:38 AM
Personally I'd prefer to write an application using Java/DOM APIs that would read the db and spit out the XML.To me its the best and cheapest way,on the other hand,if you think thats hard to do then there are utilities that can do it for you, XMLSpy is one of those.

Cheers

Khalid
AWhiteC
03-10-2003, 12:23 PM
Thanks Khalid, but I'd have to get a Java development environment and learn it first! I suppose I could use VS.NET.

I've got XML Spy, but only the home version, which doesn't (I think!) do that function.
khalidali63
03-10-2003, 05:18 PM
It should not be too hard to do this with VB,
I could help you with Java but never tried creating/writing XML with VB..:-(

Cheers

Khalid
AWhiteC
03-10-2003, 08:12 PM
I'm looking into using Delphi 7 for this at the moment, Khalid. I'll let you know how it goes. Thanks for the help.
khalidali63
03-11-2003, 04:40 AM
Sounds good..:-)


:p

Khalid
AWhiteC
03-13-2003, 07:11 AM
I didn't use Delphi 7 after all - I only have the Personal edition, which lacks the functionality I need.

So, I turned to my VS.NET Beta 2 - created an adapter and a dataset basically using drag-and-drop, and typed about 5 lines of C# in - and now I have an XML file from the database!!

Next problem. I want to convert the XML to HTML, so I need an XML Stylesheet. The problem comes when I try to output a link to a file ...
<td> <a href="<xsl:value-of select="FileLink"/>"> Click Me </a> </td>
... there's a syntax problem with double-quotes in there. Any suggestions?
khalidali63
03-13-2003, 07:51 AM
use html entities
&amp;quot;

This should take care of it

Khalid
AWhiteC
03-13-2003, 02:06 PM
Khalid,

You are brilliant! Thanks. :)
AWhiteC
03-13-2003, 03:21 PM
Hang on, that didn't work ...
khalidali63
03-13-2003, 07:19 PM
Ok her eit goes man,I think you are trying to create a link using XSL,if thats the case you are doing it completely wrong,here is the correct syntax.

<td>
<a target="_blank">
<xsl:attribute name="href">
<xsl:value-of select="FileLink"/>
</xsl:attribute>
Click Me
</a>
</td>

Cheers

Khalid
sudhir_m8
10-05-2008, 05:08 AM
Hi White,
I have come across this forum while searching for sample code to convert a MDB file into XML file.In this forum you said that, you have written the code for converting the mdb file into xml file. no contact information.
Thanks in advance....

Rgds,
Sudhir M




What's the easiest way to convert an MDB file (Access database) to an XML file? (Oh, and what's the cheapest way??)