XML to MDB conversion

[Northern Light]

does anyone know of a freeware or shareware utility that will convert XML
files to Access (MDB)?

is there any programming involved in conversion?

 

[Danny J. Lesandrini]

Funny you should ask.

I don't have a utility, but I'm currently working on an article for
Database Journal that has this for its topic. I've got a code sample
that performs the import and I'm working on the explanation. If
you want to browse my code, I'll gladly send it to you. Just drop
me a line at (e-mail address removed)

By the way, I'm not aware of any utility that simplifies the process.
I was told that you'd have to understand the composition of your XML
and use the DOM to step through records, adding parent and child
records in order ... which is how I approached it.

If there is a utility, I'd like to know before I write this article

 

[Northern Light]

the only utility that comes close that i know of is here:

http://rustemsoft.com/download3.htm

it's $60.00, though there is an evaluation version for download.

a co-worker and i will be converting xml files for use in Access 2003. i
know a little bit of VB but i profess to be a novice programmer. so is my
co-worker.

 

[Danny J. Lesandrini]

Well ... not really. That utility exports an Access table to XML.
I had that code written back in 1998 already. Doesn't help here.

 

[Matthias Klaey]

Well ... not really. That utility exports an Access table to XML.
I had that code written back in 1998 already. Doesn't help here.

In Access 2003 it should be possible to import .xml and .xsd
documents; however, I have not yet tested this myself.

HTH
Matthias Kläy

 

[Danny J. Lesandrini]

Well, I'm sure it's possible, but parent-child records get lost, at
least in the case of my schema. I haven't tested it with other files,
but I have a feeling the import is primative at best. Probably better
than it used to be, but not able to allow you to bring it all in cleanly.