MS SQL export works just like MS Access export. However, here you only have to select the server and no standard database when crating an ODBC connection. After that, you can rename the database in Lan-Inspector, create a new one or delete it. The rest is similar to the Access export. If fields are greyed out, press ‘Test’. You will need the relevant permissions on the SQL server.
If you use MS Access frontends as input masks to access an SQL server, problems may arise when also exporting the 20 data fields. (Access cannot do that). Therefore, you have the option to omit these fields when using this kind of connection.