Results 1 to 4 of 4

Thread: Vb6/sql2000/xml

  1. #1
    Join Date
    Aug 2003
    Location
    Jhb
    Posts
    20

    Unanswered: Vb6/sql2000/xml

    I'm desperately in need of a sample piece of code that will show me how to, using VB6, import an XML file into a SQL 2000 table. If there is anyone able to assist, it would be GREATLY appreciated.

    Regards...

  2. #2
    Join Date
    Aug 2003
    Location
    Jhb
    Posts
    20
    or even how to setup a stored procedure that can be triggered by VB6 to import the XML file...

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can either do it from T-SQL (SP) by passing a parameter of type TEXT to it and then writing it to the table using WRITETEXT, or you can do it from your VB app using AppendChunk (RDO) or rs.AddNew/rs.Update (ADO).

  4. #4
    Join Date
    Aug 2003
    Location
    Jhb
    Posts
    20
    Thanks for your reply... Do you perhaps have a sample ?

Posting Permissions

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