I never liked the idea that MSSQL worked only for windows machines, that was for years. It’s obvious that Microsoft slowly changes the company business strategies, at last 🙂 Here is an article about installing Microsoft SQL server 2017 on Ubuntu 16.04. It’s just the beginning. Microsoft needs  a change. We will see if it really works. Of course don’t expect that runs like mysql with very low specs, mssql…

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 = cn ‘ cn is database function to establish connection to sql server, Dim xDoc…