Not really a problem but there are 5 access databases and one SQL Server on prem. A job has been created on the SQL Server to export data from these Access databases to the on prem SQL. This is all in place and working.
Now they have the SQL in Microsoft Azure SQL Database (Not a managed Instance). The issue is that internal developers can seem to get the script to work and there investigations point to the OPENROWSET Function part of the script as after some investigation it appears as this will not work in Azure SQL.
Others have written that you can get around this with using Linked servers however Linked servers are only available using a SQL managed instance and only to On Prem SQL.
So my question is Simply. I have an access database, I want to export data from it to an Azure Sql Database and automate the process as it needs to happen daily. How Can i do this and if you can provide more details that would be great some pointers to some scripts etc but it is important that it works with Azure SQL Database not Azure Managed instance or On Prem.