SQL Server Performance

MS Access, XML Output question

Discussion in 'General Developer Questions' started by cbtoolkit, Jun 30, 2005.

  1. cbtoolkit New Member

    I have, what I hope, is a very simple question..

    I want to be able to query a SQL DB and output using the "for XML auto, ELEMENTS" clause and bring the XML as text into Access. Ultimately, I am going to create a file from the Access application.

    I've read a few different examples regarding a stream object from an ADO command. If I simply run an ADO recordset using the for XML Auto, ELEMENTS command, I do not get the elements. I end up with field names and gibberish - a series of ??? and other characters.

    Any good articles on which way to go on this?

    Thanks,
    Matt

Share This Page