Hello everyone,
What's the best way to use VBA to transfer the contents of an Access table to a Microsoft Cloud SQL server (Azure) on a daily basis?
I have a table with around 60-70 rows, and it takes hours when for example linking the SQL Server table and using INSERT INTO takes many hours.
Using some kind of stored procedure and sending multiple lines in every execution is reasonable fast at first but seems to slow down a lot after some time for some reason.
Thank you
What's the best way to use VBA to transfer the contents of an Access table to a Microsoft Cloud SQL server (Azure) on a daily basis?
I have a table with around 60-70 rows, and it takes hours when for example linking the SQL Server table and using INSERT INTO takes many hours.
Using some kind of stored procedure and sending multiple lines in every execution is reasonable fast at first but seems to slow down a lot after some time for some reason.
Thank you