XML from MDB

[AWhiteC]

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

[khalidali63]

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]

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]

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]

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]

Sounds good..:-)




Khalid

[AWhiteC]

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]

use html entities
&amp;quot;

This should take care of it

Khalid

[AWhiteC]

Khalid,

You are brilliant! Thanks.

[AWhiteC]

Hang on, that didn't work ...

[khalidali63]

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]

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. [mod]no contact information[/mod].
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??)