Complex Xml Import

[Limo]

Dear all,

I have to import an xml-file in an existing access
database. The problem I have is the following:

The xml-file needs to be distributed over several tables
in the database but first needs to be transormed with
xslt to the right format.

One of the problems that has occured is that Access will
associate one table with one xml-file.

I got a tip on how to fix this problem. (The tip was: use
xslt to create a file with a number of update/insert
queries.) The problem is that I have no idea on how to
put this into practice. How will Access know what to do
with my xslt-output? Is it ok that I just generate sql-
queries?

Does anybody have any suggestions on how to solve this
problem?

Thanks in advance,

Limo

 

[Joe Fallon]

A2003 has much improved support for XML.
It can import data to multiple tables.
You may still need to write XSLT (not sure) but you should find a copy of
A2003 and give it a try first.