Store XML in a Database

From: Stefan Garde (stefangarde_at_hotmail.com)
Date: 10/21/03 

Date: Tue, 21 Oct 2003 18:12:05 +0200

I need to figure out how you store a XML file (and its data) down in a
Access database, by the help of SQL.

I have tried looking through the net, but havent been very lucky (only found
a course on how to do it, which was in america somewhere i think).

I work in Java, so would be very happy if someone had some code example from
that or a link. But anything is acceptable really.

Hope to get some response

Regards,
Stefan

Relevant Pages

  • Re: Store XML in a Database
    ... > Access database, by the help of SQL. ... Do you need to just store the XML string or convert it into its ... the XML file maps to the database. ...
    (comp.lang.java)
  • problem while loading xml doc to a schema based table]
    ... One stage of my project is to store an xml file into a table of ... SQL> ALTER SESSION SET EVENTS='31098 trace name context forever'; ... SQL> create table struc_100kb(xmldoc sys.xmltype) ... xmltype column xmldoc store as object relational ...
    (comp.databases.oracle.server)
  • Re: small data needed - suggestions?
    ... Or store it in a xml file ... "waste" one on a small project like this. ... SQL Express is not supported either. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Access to SQL
    ... I have some users that use an access database to store ... I was wondering if there is a way to import this access file into SQL and ...
    (microsoft.public.sqlserver.server)
  • Store data into Access
    ... I have a small table in an Access database, ... I want to store 3 values into a record. ... So I guess I can just use this SQL in a OleDbCommand. ... I just found out about DataRows by reading some answers in this discussion area -- is that a good way to do it? ...
    (microsoft.public.dotnet.languages.vb)