Hello,
I have built an import button on a form which when clicked, transfers data from an excel spreadsheet (through file dialog picker) to a temp table. It then uses an append query to append the new data to a sql server linked table.
It is working well with small volumes of data. However, beyond 40 000 rows, it comes up with this error message:
Run-Time Error '3035': System resource exceeded
How do I solve this?
I have built an import button on a form which when clicked, transfers data from an excel spreadsheet (through file dialog picker) to a temp table. It then uses an append query to append the new data to a sql server linked table.
It is working well with small volumes of data. However, beyond 40 000 rows, it comes up with this error message:
Run-Time Error '3035': System resource exceeded
How do I solve this?