- Right click relevant SQL database < Task < Import Data
- Data source: Microsoft Access (Microsoft Access Database Engine)
- Destination (Azure SQL): Microsoft OLE DB Driver for SQL Server (Also choose "Active Directory - Universal with MFA support " in Properties togheter with server name and your username. Then choose relevant database)
Known issue: Importing tables can produce exceptions in some cases. Rows can contain wrong DateTime format values - these needs to be editet. Replace these incidents with NULL/empty values