DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: XML into Access/SQL Server

  1. #1
    Markej Guest

    XML into Access/SQL Server


    Hi,
    I have a problem which hopefully you guys can help with!
    I have a programme that will receive periodically xml files from another
    system, the xml files will have been created using ADO and the structure
    will be identical to the table I'm importing to. Infact I will probably delete
    the table contents before adding this data. I have to hold it in a database
    as I need to run queries where this data is joined with other tables.
    I know how and can open the xml as a recordset in VB I JUST can't "save"
    it into the table currently in Access.. HELP!!!

    Mark

  2. #2
    Chris Hylton Guest

    Re: XML into Access/SQL Server


    Because the XML based recordset was created from a different source database
    (I assume), you aren't going to be able to just reconnect it to another database
    and have it automatically update another table.

    You will need to loop through the XML based recordset once you open it from
    the file, and just process the records into the secondary table one by one.
    Basically, either build insert SQL statements for each record and run cn.execute
    w/ the insert statement...OR...open a second recordset on your destination
    table and do .addnew/.update in the loop.

    Chris

    "Markej" <marke@virgin.net> wrote:
    >
    >Hi,
    >I have a problem which hopefully you guys can help with!
    >I have a programme that will receive periodically xml files from another
    >system, the xml files will have been created using ADO and the structure
    >will be identical to the table I'm importing to. Infact I will probably

    delete
    >the table contents before adding this data. I have to hold it in a database
    >as I need to run queries where this data is joined with other tables.
    >I know how and can open the xml as a recordset in VB I JUST can't "save"
    >it into the table currently in Access.. HELP!!!
    >
    >Mark



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center