Export data from MS Access to SQL Server?

Question

SQL

1. There is no Export to SQL Server Wizard in Access 2016.
2. Migration Assistant, after connecting to the server, it gives an error.
3. When imported via SSMS, queries are imported as tables and cannot be viewed or modified. Relationships between tables are also not imported.
What other export options are there?

Answer 1

What kind of SQL Server is this? Microsoft SQL? MySQL server? PostgreSQL?

Answer 2

Yes, a lot of different ones. For example, reduce the version of the access to the one in which there is an export. :)