MS Access, XML Output question

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