Using VBA in MS Access (or any VBA-enabled tool such as Excel, Word, etc.), we can interact with web services to push/pull data to/from a database such as Microsoft SQL Server. Below we are consuming a .Net Web Method in our Web Service that returns a DataSet, creating an XML Document and looping through it [...]
