Blog Posts

Export from mssql table to xml file (in my case 2016) First, in access you need to enable xml library Secondly, create a function within vba module similar to the one I made. Option Compare Database Option Explicit Dim sqlCommand As ADODB.Command Dim conn As ADODB.Connection Dim rst As New ADODB.Recordset Public Function ExportaXmlImportexBCM() Set conn […]