Browse by Tags

The XML Is On The Kid

Published Thu, Mar 11 2010 23:08 | Bob Phillips

I recently wrote about a database tool that I have built to facilitate adding stored procedures to databases, SP Builder . XL-Dennis made a couple of comments, one of which was with regards to the medium used for the script file. He talked about XML files...

Filed under: 2007, Excel, Autogen, VBA, Stored Procedures, 2010, SPs, 2003

The Kid Grows Up

Published Wed, Mar 3 2010 12:41 | Bob Phillips

In a previous post , I talked about building stored procedures (SPs)in an Access database, and calling the same from Excel using ADO. As I mentioned in that post, I am not a fan of the Access GUI. Whilst GUIs can be okay for doing some simple testing...

Filed under: Excel, Autogen, VBA, Excel 2007, Stored Procedures, SPs