InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 23:50:54 GMT20http://www.sqlservercentral.com/Forums/Topic1356594-131-1.aspxI'm in way over my head on this, as I've never done any .NET programming or worked extensively with xml, but in theory I don't see any reason why it wouldn't work. But it's not clear to me what value there would be in using an Access front-end to do that sort of thing when there are other tools with fewer limitations. It seems a bit like trying to pound a nail in using a screwdriver.Sat, 29 Sep 2012 07:21:33 GMTWendellBhttp://www.sqlservercentral.com/Forums/Topic1356594-131-1.aspxThanks, so with Access can you manipulate namespaces like you see doing here> http://www.sqlservercentral.com/Forums/Topic1360396-21-1.aspx?Wed, 19 Sep 2012 00:43:50 GMTgrovelli-262555http://www.sqlservercentral.com/Forums/Topic1356594-131-1.aspxI don't see why you couldn't use a pass-through query to invoke the SQL Server function - although there are several limitations with pass-through queries. But Access has had the ability to read and import XML files (that are well structured) since 2003, and can display it in a tabular format, so I would probably do it that way.Mon, 10 Sep 2012 06:42:25 GMTWendellBhttp://www.sqlservercentral.com/Forums/Topic1356594-131-1.aspxHi guys, I'm not knowledgeable about XML or T-SQL but do you know whether it's possible to use syntax such as Arthur's revised query in Access?I know that Access can run stored procedures in SQL Server but can the above be considered a stored procedure?http://www.sqlservercentral.com/Forums/Topic1355591-21-1.aspxMon, 10 Sep 2012 02:45:48 GMTgrovelli-262555