Francisco Tapia
fhtapia at gmail.com
Mon Oct 24 23:39:29 CDT 2005
converting to XML is just a matter of using the for xml feature, I've yet to find a good method of extracting the for xml feature straight out of sql server. Generally I build a webservice (if this data will be used often) otherwise just a view and export right out of Access 2003 as XML. (what do others do?) On 10/24/05, Julie Reardon-Taylor <prosoft6 at hotmail.com> wrote: > > > Anyone have experience using an ODBC connection to retrieve data from this > system and convert it to XML? > > > Julie Reardon-Taylor > PRO-SOFT OF NY, INC. > 44 Public Square Suite #5 > Watertown, NY 13601 > Phone/Fax: (315) 785-0319 > www.pro-soft.net <http://www.pro-soft.net> > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More...