Excel/VBA/ADO
I am doing import to an Access database from records in an Excel file.
During import I can see the use of memory is increasing (I have the windows joblist open).
I have tried performing commit for every 1000 record (and then start new transaction). That didn't help.
After import, and all connections and files are closed, Excel won't release used memory.
Only when I close Excel, memory is released.
Has anyone an input for this - e.g. how to release memory during the import.
Best regards,
Thomas
Bookmarks