Complex Xml Import

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Limo (anonymous_at_discussions.microsoft.com)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 11:33:51 -0800

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

Relevant Pages

  • Re: Complex Xml Import
    ... > The xml-file needs to be distributed over several tables ... > xslt to the right format. ... > queries.) ...
    (microsoft.public.access.externaldata)
  • Re: Publishing Database data?
    ... analysis) and after that you may "transform" this xml-file using xsl-file ... Or generate the static html-pages with information from database ... and generate the xsl-file automatically. ... > from our database so that its easy to retrieve. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: reading XML string and writing it to a SQL database
    ... Microsoft parser) and insert these values to your database. ... you may use the SMImport suite: http://www.scalabium.com/smi ... Your xml-file will be parsed by TSMImportFromXML without any problem and ...
    (borland.public.delphi.database.ado)
  • Trouble writing to database: RSS-reader
    ... start-tag and the end-tag) is on the same line, ... The problem is that i cant find the data in the database! ... downloads the .xml-file from the web and saves it in the buffer. ...
    (comp.lang.python)
  • Class to update db-structure
    ... I am searching for a class which is able to update a sql-server db-structure ... about definitions for example in a xml-file. ... I have a database which ...
    (microsoft.public.dotnet.languages.csharp)