How to import/export data from sql with vba access
![](/wp-content/uploads/2020/12/angelo-abear-knTKij60p3g-unsplash-scaled-e1673358905842-768x421.jpg)
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…