September 10, 2012 at 2:45 am
Hi 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.aspx
September 10, 2012 at 6:42 am
I 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.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
September 19, 2012 at 12:43 am
Thanks, so with Access can you manipulate namespaces like you see doing here> http://www.sqlservercentral.com/Forums/Topic1360396-21-1.aspx
?
September 29, 2012 at 7:21 am
I'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.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply