MS Access (Office365) performance question
I have a process which requires saving up to 1000 records in a MS SQL Server backend database.
Currently I collect the data for each record, and then use an insertinto command, once for each record.
This process takes a very long time... up to 7 minutes on very fast windows10 computers with a windows 2016 server, although the ms sqlserver is running on a 3GHz win7 workstation with 32MB.
Is there a faster way to save 1000 rows than using the InsertInto command once for each row?