help needed to convert ms access mdb files to xml files

[Moieen Khatri]

Hi,

I have a directory structure containing MS Access (mdb files) .I need to convert each mdb file to corresponding xml,xsd files.

Can someone help me with the java api/documentation that I could use to perform this task?

Would really be thankful if someone could post some sample code for the conversion.

Thanks

[William Brogden]

Since you dont say what the resulting XML is to be used for I will have to take a guess.

Your first step will be to define what you want the XML to look like.

I suggest using a text editor to create an example XML document using reasonable data.

Bill

[Moieen Khatri]

Thanks for your response!

The Xml will contain the data that is inside the mdb database files.I need to read the mdb files and the data inside it using Java api which I am not sure which one to use and create corresponding xml files for each mdb file.

I want to convert this(from mdb to xml) as it is the required format for our supporting application.

The format of the xml file is something similar to the one seen below:

<?xml version="1.0" encoding="iso-8859-1" ?> 
- <TABLE>
 - <DURSME_1>
   <PATNO>101</PATNO> 
   <sumdur>772</sumdur> 
   <___newcd>1</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>102</PATNO> 
   <sumdur>29</sumdur> 
   <___newcd>2</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>103</PATNO> 
   <sumdur>164</sumdur> 
   <___newcd>3</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>104</PATNO> 
   <sumdur>36</sumdur> 
   <___newcd>4</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>105</PATNO> 
   <sumdur>144</sumdur> 
   <___newcd>5</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>106</PATNO> 
   <sumdur>36</sumdur> 
   <___newcd>6</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>107</PATNO> 
   <sumdur>108</sumdur> 
   <___newcd>7</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>108</PATNO> 
   <sumdur>332</sumdur> 
   <___newcd>8</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>109</PATNO> 
   <sumdur>144</sumdur> 
   <___newcd>9</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>110</PATNO> 
   <sumdur>292</sumdur> 
   <___newcd>10</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>111</PATNO> 
   <sumdur>157</sumdur> 
   <___newcd>11</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>112</PATNO> 
   <sumdur>54</sumdur> 
   <___newcd>12</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>113</PATNO> 
   <sumdur>8</sumdur> 
   <___newcd>13</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>114</PATNO> 
   <sumdur>33</sumdur> 
   <___newcd>14</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>115</PATNO> 
   <sumdur>36</sumdur> 
   <___newcd>15</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>116</PATNO> 
   <sumdur>72</sumdur> 
   <___newcd>16</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>117</PATNO> 
   <sumdur>108</sumdur> 
   <___newcd>17</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>118</PATNO> 
   <sumdur>194</sumdur> 
   <___newcd>18</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>119</PATNO> 
   <sumdur>11</sumdur> 
   <___newcd>19</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>120</PATNO> 
   <sumdur>115</sumdur> 
   <___newcd>20</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>121</PATNO> 
   <sumdur>50</sumdur> 
   <___newcd>21</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>122</PATNO> 
   <sumdur>46</sumdur> 
   <___newcd>22</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>123</PATNO> 
   <sumdur>7</sumdur> 
   <___newcd>23</___newcd> 
   </DURSME_1>
 - <DURSME_1>
   <PATNO>124</PATNO> 
   <sumdur>71</sumdur> 
   <___newcd>24</___newcd> 
   </DURSME_1>
   </TABLE>

Regards

Moieen

[Paul Clapham]

Just create a FileWriter (with encoding ISO-8859-1) and write the XML document to it.

[Moieen Khatri]

Is there any Java class/api to read the data from the files with .mdb extensions?(MS-Access files)

Regards

Moieen

[William Brogden]

So apparently you just want to turn a table into a XML document, not combine data from multiple tables.

You might be able to use the ServingXML toolkit - an open source project.

As I recall, the download includes SQL database to XML tools.

Bill

[Paul Clapham]

Moieen Khatri wrote:Is there any Java class/api to read the data from the files with .mdb extensions?(MS-Access files)

That's JDBC.