Results 1 to 5 of 5

Thread: Storing XML to a database

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Dec 1999
    Location
    San Francisco
    Posts
    16

    Post

    Hi,
    Does anyone know the procedure to store the data from the xml into an existing access database.

  2. #2
    Hyperactive Member Gimpster's Avatar
    Join Date
    Oct 1999
    Location
    Redmond, WA 98052
    Posts
    331

    Post

    Are you talking about how do you convert it? Because if that's what you mean, you shouldn't have to convert it. XML is supposed to be a universal coding similar to HTML, meaning it would be completely platform independant and also program independant. So you shouldn't need to convert it, that is assuming MS did a good job creating XML!

    ------------------
    Ryan

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Dec 1999
    Location
    San Francisco
    Posts
    16

    Post

    I don't want to convert the data. I want to import the dat from the XML file into the access database.

  4. #4

    Thread Starter
    Junior Member
    Join Date
    Dec 1999
    Location
    San Francisco
    Posts
    16

    Post

    I don't want to convert the data. I want to import the dat from the XML file into the access database.

  5. #5
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    Just open it and read it like any other text file, and store it in a text/memo field.

    XML documents are all text, no binary, so it should be pretty simple

    HTH

    Tom

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width